Sr. SQL Developer/ DBA
5260 Western Ave Bethesda, MD 20810
Sr. SQL Server Developer/ DBA
* Contribute to the creation of standards for SQL Server database administration that supports the use of optimal database server resources and performance. *Defining requirements for automating routine database service delivery processes. *Collaborate with peers on developing and enhancing existing database service delivery automation solutions *Implements and maintains automated database maintenance plans and backup routines using standard methodologies. * Lead performance monitoring and tuning of assigned projects and communicate with other teams for identifying root cause of all database related issues. *Assist junior engineers in managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. *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 to meet business needs *Design, troubleshoot and optimize SSRS reports to meet business needs *Independently analyze, 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. *Share domain and technical expertise, providing technical mentor-ship and cross-training to other peers and team members. *Performance tuning, ongoing maintenance, backup/ recovery, security, auditing, production support, migration, *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
*Participate in the 24/7 rotational On-Call schedule
*8+ years of experience administering large databases in a high transaction, 24x7 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
*Experience with Performance Tuning and Optimization, using native and third-party monitoring and troubleshooting tools.
*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 of SQL Server High Availability (HA) and Disaster Recovery (DR) options for SQL Server. *Advanced knowledge of SQL Server AlwaysOn availability groups and Failover Cluster Instances.
*Advanced knowledge and experience administrate ring Windows Server, including Active Directory and failover clustering
*Strong skills and working knowledge in database partitioning, security and encryption.
*Production support experience should include support of SSIS, SSRS, replication, database mirroring and SQL Reporting Services. In depth experience with DacPac, BacPac and IsPac concept and deployment and automation of database objects is required. *Advanced PowerShell scripting experience. Knowledge of PowerShell for SQL is a plus *Experience with SQL Server Reporting Services, SQL Server Integration Services and/or SQL Server Analysis Services. *Advanced working knowledge of Firewall and network security concepts