Database Administrator

• 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.