Microsoft Database Administrator, SQL

Looking for engineers that are looking to shine and showcase their database skills by stepping into the SME (subject matter expert) role for SQL database.

This position administers a data warehouse environment including determining overall design, processes, procedures, safety/security, and storage/retrieval. Determines high-level business information needs and identifies system requirements.
 
DBA Skill Set required for job responsibilities:

• Creates new MS 2000/2005/2008 databases including schema normalization, performance tuning, clustering, and load balancing. Works with reporting analysts, developers and other DBAs to plan, design, create and implement new databases.
• Resizes existing databases based on growth. Works with the application development and reporting teams to create in-line queries, stored procedures, indexes, triggers, DTS/SSIS packages. Provides recommendations around query methodology to ensure top performance.
• Ensures proper maintenance plans on all MS SQL databases including data backup, truncate logs, shrink databases. Determines optimal schedule for maintenance execution. Creates security policies for individual users and implements them with SQL Server Windows NT Authentication. 
• Monitors server performance and health utilizing NT Performance Monitor, System Event log and other alerts to watch the database servers.
• Performs migration of MS SQL databases and support jobs from SQL Express/SQL 2000 to SQL 2005/2008. Converts DTS packages to SSIS packages.
• Installs and deploys new MS SQL database servers in stand-alone and clustered load balanced SAN environments on 32 bit and 64 bit servers. 
• Creates and manages database servers with multiple instances of SQL server. Designs and implements data extracts from multiple data sources (Oracle, SQL Server) for querying and import to MS SQL database systems.
• Meets with internal groups and end-users to gather both high-level and detailed information needed to scope out proposed applications, reports/reporting systems and/or enhancements to existing systems from a database and data warehousing perspective.
• Database disk sizing methods, identifying issues with existing systems and providing recommendations to improve database clustering and configuration.
• Providing a secure SQL environment using Symantec Endpoint, Tripwire and build according to security SQL principals.
• VMWare VM operational checks
• Netapps disk storage sizing according to database iops requirements.

 
MS SQL DBA - QUALIFICATIONS: 

• Bachelor's degree (B.A.) in Computer Science and 3 to 5 years related experience and/or training; or equivalent combination of education and experience.
• Must have 3+ years hands on experience with Microsoft SQL Server 2000/2005/2008 and Windows Server 2000/2003/2008 environment.
• Must know in detail of MS SQL server, including T-SQL, stored procedures, indexes, performance monitoring and adjustments, ODBC connectivity, DTS packages, Backups, SQL Job Agent and Security. 
• Must be skilled with performance monitoring, tuning, and implementation strategies. Server software packages include: Veritas Backup Exec, Diskkeeper, Oracle for Windows.
• Must know the interoperability and network requirements of database and data warehouse implementations between web based and/or Access clients and the database server backend.
• Full understanding of clustering concepts, replication and log shipping SQL Database 2005 and 2008 Knowledge. 
• Secure database according to secure computing guidelines.
• Must have some familiarity with SQL Plus, basic Oracle administration, and ODBC connectivity to Oracle systems (versions 10g and 11i).

 
Personality Traits

• Previous experience participating in or leading application development or reporting systems development projects required.
• High-level understanding of project management principles and change control processes required.
• Must be able to handle multiple priorities in a fast-paced, deadline oriented environment. 
• Requires effective written and verbal communications skills at all levels.
• Requires excellent problem solving and trouble shooting skills, along with the ability to work independently and as a member of a team when needed. Requires extreme attention to detail.
• Must be customer focused and understand how to effectively anticipate and then proactively address end-user questions or concerns.
• Must be highly motivated and aggressive in resolving business problems.
• Must possess ability to analyze and solve problems; efficiently handle multiple duties under pressure; work flexible hours as required.