Senior Sql Database Administrator

OverviewEnterprise 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 EnvironmentHigh availability production applications and serversMicrosoft product stack: sql server, .net. , ssis/ssrs/ssas.MDM and Big DataCloud-awsTableau BIThe RoleAs 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/ssasJob 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..