Database Administrator
At a glance
Mid-level Data Architecture & Governance role at USM. Austin · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Administer operational databases, troubleshoot failures and resolve database issues as they arise
- Use SSIS to normalize and transform data from separate sources before loading a data warehouse
- Build and support SQL Server integration, analysis and reporting services, plus SQL programming
- Maintain database security, backups, performance, indexing and version control
What you bring
- At least five years administering databases in production, including SQL Server or another DBMS
- At least eight years working with SSIS, SSAS, SSRS and SQL Server programming
- Hands-on command of SQL Server administration, security, recovery, performance tuning and data modeling tools
- Experience using SSIS to handle complex data transformations and warehouse loads
Who this fits
This mid-level contract role is onsite in Austin. It suits someone with substantial operational database administration experience and deep SQL Server services and programming experience.
From the employer
USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.
Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.
Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.
USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.
• Minimum 5+ years of professional Database Administration experience in an operational environment particularly with Microsoft SQL Server or 2 years SQL Server and 3 or more years using a different DBMS.
• Minimum 8+ years extensive experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server programming
• Skills and Tools required for Microsoft SQL Server 2012:
• Management Tools - Management Studio, SQL Profiler, SQL CMD, SQL Agent, Tuning Advisor
• Programmability & Development Tools - T-SQL Queries (DML, DDL, TCL), SQL Data Tools
• Security - User, Roles, Auditing
• High Availability - Database Backup & Restore, Log Shipping,
• Scalability and Performance - Indexing, Partitioning
• RDBMS Manageability - PowerShell Scripting, Performance Report, Index Maintenance
• Integration Services - Configuration, Import - Export, SSIS Designer, Data Profiling, Transformation
• Reporting Services - Report Server Configuration
• Data Modeling - Erwin (CA) and/or ERStudio (Embarcadero)
• Microsoft Office 2013 - Word, Excel, Visio
• Apache Subversion (SVN) - Versioning and Revision Control System
• Experience in troubleshooting and resolving database problems
• Experience using SSIS to implement complex normalization and transformation logic to load data into a data warehouse from disparate data sources.
Environment:
• Microsoft Server 2012
• VMware Environment
Optional Skills:
• SQL Server 2012 - Replication, Analysis services
• Certification - MCDBA or MCSA
If you are interested in above position, please share your updated resume to mohammedm(at)usmsystems(dot)com or can directly call me on 703-880-2641.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.