This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Find jobs in Maryland today!

To post a job, login or create an account |  Post a Job

  Jobs in Maryland  

Bringing the best, highest paying job offers near you

previous arrow
next arrow
Slider

SQL Server Consultant

Triune Infomatics Inc

This is a Contract position in Chevy Chase, MD posted June 6, 2021.

Senior Microsoft SQL Server Database Engineer/Architect

Duration: 6 Months

Location: Chevy Chase, MD

 

 

• Lead performance monitoring and tuning of assigned projects and communicate with other teams for identifying root cause of all database related issues. Proactively support ongoing maintenance, backup/ recovery, security, auditing and production support.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Design, troubleshoot and optimize SSIS and ETL packages and SSRS reports to meet business needs

• Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.

• Assist developers with complex query tuning and schema refinement.

• Routinely evaluates/ implements improved methods or processes for administering and maintaining databases and servers.

• Perform scheduled maintenance and support release deployment activities after hours.

• Participate in design and architecture review of the databases and applications. Lead efforts with database topology review and communicate with multiple teams to finalize optimal design for databases and applications.

• Serve as escalation point for troubleshooting minor to major problems on an as-needed basis; often requiring time sensitive response and pro-active communication to different groups within the organization Requirements

• Contribute to the creation of processes, procedures and standards for SQL Server database administration that supports the use of optimal database server resources and performance to minimize potential downtime scenarios

• Defining requirements for automating routine database service delivery processes and collaborating with peers to develop and enhance existing database service delivery automation solutions

• Implements and maintains automated database maintenance plans and backup routines using standard methodologies.

• Participate in the 24/7 rotational On-Call schedule.

 

Daily Responsibilities:  

-8+ years of experience administering large databases in a high transaction, 24×7 Microsoft SQL Server database environment.

-Advanced skills in resolving database locking conflicts/blocking and resource utilization contention

-Ability to work with database developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics. Demonstrate ability to solve complex database administration problems.

-Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2012, SQL Server 2014, SQL Server 2016 and SQL Server in Azure IaaS

-A thorough understanding of Performance Monitoring, Tuning and Optimization, using native and third-party monitoring and troubleshooting tools like IDERA/Redgate/OMS MMA or Dynatrace is required

-Advanced knowledge of SQL Server backup and recovery strategies. Experience defining hardware requirements and storage capacity planning for development, testing, QA and production for capacity planning and performance

-Advanced knowledge SQL Server Disaster Recovery (DR) options, AlwaysOn availability groups and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security and encryption

-In depth experience supporting SSIS, SSRS, replication, database mirroring, SQL Reporting Services, DacPac, BacPac, IsPac concept and deployment/automation of database objects is required

-Advanced PowerShell scripting experience with ability to write automated scripts and strong knowledge of system tables and DMV’s is required.

-Must be self-motivated, able to work in a team-oriented environment as well as possess the ability to organize, plan and lead projects independently. Share new ideas with the team and be able to think on your feet and recommend solutions.

-Ability to work in a fast-paced environment, rapidly develop proficiency in new skills with a strong work ethic and a professional demeanor

-MCDBA or MCSE: Data Platform Required with at least MCSA SQL Server 2012/2016

-MCTS, MCITP, and/or MVP certifications a plus

-Previous experience working as part of an Agile/Scrum organization

 

If interested then pl. share your resume to gagan@triuneinfomatics.com or call me on 510-400-1456

AL Jobs AR Jobs CA Jobs GA Jobs KS Jobs KY Jobs LA Jobs MD Jobs MI Jobs MN Jobs MS Jobs MO Jobs NY Jobs OR Jobs TN Jobs TX Jobs UT Jobs VA Jobs WV Jobs ID Jobs