Senior Sql Database Administrator

Overview

Enterprise level Microsoft application/sql server environment requires sql server application and dba server integration set up- will be joining our DW implementation team on greenfield SQL server DW build.

The Environment

• High availability production applications and servers
• Microsoft product stack: sql server, .net. , ssis/ssrs/ssas.
• MDM and Big Data
• Cloud-aws
• Tableau BI

The Role

As the lead dba, you will be focused on both production/application support (70-30 split), as well as database design. Will be primary contact for all application development tasks as it pertains to ssis/ssrs/ssas

Job Description:

• The position will work directly with various IT associates including Application Development, Server Admin, Networking, Database Administration, and others to optimize application / database performance.
• Candidate should have hands on experience with large scale environments and high transaction volumes.
• The ideal candidate should have extensive Java experience.
• Experience with Mule would be a plus, but not required.

Specific Duties:

• Advanced Database Development experience with Microsoft SQL Server Database.
• Experience with Senior level Database Administration support. (e.g., Installing / Upgrading / Backup and Recovery / Configuring / SSMS / SSIS / SSRS / Always on Failover Clustering / Performance Tuning / Troubleshooting).
• Evaluating SQL Server Query performance.
• Providing guidance on query redesign, index modifications, database configuration changes, and database related application process improvements.
• Utilizing Idera SQL Diagnostic monitor, Query Store, SQL Server Profiler, Dynatrace and Query plans to evaluate and tune database queries.
• Evaluating index statistics/fragmentation.
• Creation of SQL Server performance documentation/best practices for consumption by SQL Server Database Development and Database Administration teams.
• Participate in evaluations and recommendations for associated database solutions based on business requirements and user needs.
• Provide performance monitoring and measuring of all database components and provide input on capacity and performance planning.
• Escalate issues for technical assistance as required.
• Participate in basic to moderately complex database tuning efforts as required.
• Apply administration best practices in daily operations.

Qualifications:

• Industry-recognized technical certification preferred (e.g. SQL, MCDBA)
• Working Knowledge of database file structure, retrieval and access methods, and performance analysis.
• Demonstrated analytical skills, excellent written and verbal communication skills, judgment, and the ability to work effectively with clients and IT associates in a collaborative and cooperative manner.
• Basic Understanding of the development process and business process.
• Ten (10) or more years’ related IT experience working as a SQL Server database administrator and familiarization with related technologies and tools.
• The candidate should have Database Development experience in large scale environments with high transaction volumes such as ecommerce or banking.

.