SQL Database Administrator

Work Arrangement Hybrid – 1-2 Days Onsite per Week (Local Candidates Only) Experience 10+years Must Citizenship/Visas Only US Citizens/ H1B'S Any visa is fine, provided the candidate has a minimum residency stay in the USA of at least 3 years for Public Trust clearance .Job Descriptio nOur client is seeking a highly motivated, flexible, organized, and detail-oriented Sr. SQL Developer/DB A to support a mission-critical enterprise application in Bethesda, MD. This is a hybrid position requiring candidates to be local to the National Capital Region and available to work onsite 1-2 days per wee k .We are looking for a strong SQL Server Developer/DB A with hands-on experience supporting enterprise applications, database administration, performance tuning, and production support .Responsibilitie sSupport a mission-critical enterprise application w/ ~17,000 users by administrating/managing the underlying Microsoft SQL Server database and providing Tier-3 user support .Work closely with other DBAs and cross-functional team for design, development, testing, verification, and implementation in database/SQL Server related activities .Provide guidance and technical support to the development team members regarding the database design/implementation .Design and create logical and physical data models .Design, develop and maintain database objects .Implement integrity constraints and indexes .Write queries, stored procedures, and triggers .Create Data Transformation Service (DTS) packages to convert and load data .Conduct performance tuning of queries and other database objects .Conduct/design code reviews .Troubleshoot SQL Server, database, production and non-production environment issues and errors .Monitor user access and security .Provide operation, technical and user support .Perform regular maintenance and deploy and verify releases .Develop, manage, and test backup and recovery plans .Develop and maintain interfaces with internal and external systems .Create, maintain, and update all system related documents .Conduct capacity planning and provide recommendations .Interface with stakeholders to understand upcoming infrastructure needs .Manage security and disaster recovery aspects of the database, including resolving security findings for MS SQL Server and the underlying operating system .Document SOPs .Perform root cause analysis and create incident reports .Setup IIS server and web configurations as needed .Write custom SQL queries to generate reports and dashboards .Perform data management and clean up .Perform routine health check of the production and non-production database environment .Occasional extended work and weekend work are required .Interface w/ end-users as Tier-3 helpdesk support for most-complex end-user related challenges which likely require back-end data-fixes .Using GitHub as a revision control system for database scripts Qualification sMinimum of 8 years practical (hands-on) experience in SQL Server database administration and data modeling providing development DBA support .Business Analysis-Data Analysis-Microsoft SQL - 5+ years exp .Database Administration-Microsoft SQL Server-CORE - 5+ years exp .Database Administration-Performance Tuning-SQL Server - 5+ years exp Preferred Skill sThorough knowledge of SQL Server databases along with skills in data manipulation mechanisms such as SQL, stored procedures, views and triggers, etc .Practical (hands-on) experience in Microsoft SQL Server database administration and support .Thorough knowledge of relational database principles, techniques, and best practices .Active Public Trust Clearance or ability to get public trust clearance .Extensive knowledge and experience in administration, programming and daily operations and support of Microsoft SQL Server versions including DTS, SQL Mail, Administration of SQL Jobs, backup and recovery, stored procedures, user defined functions, data modeling, etc .Demonstrated expertise and experience in overseeing the operations of large, mission critical Enterprise Systems database servers .Demonstrated expertise in developing mission critical data imports and exports with a diversity of data sources including mainframes, web services, FTP sites, ODBC and JDBC based data sources .Experience and expertise in the development, design, programming, and support of Microsoft SQL Server Reporting Services .Must have proven problem-solving experience as applied to the 24/7 operations of an Enterprise System .Must have user/technical support experience .Proven experience in SQL programming .Hands-on experience developing data integration solution either through the use of a tool or a custom solution .Demonstrated ability to work effectively in a fast-paced environment under deadline pressure .Demonstrated ability to manage competing priorities .Demonstrated ability to build partnerships with various teams .Demonstrated ability to communicate well and work in a collaborative team environment .Demonstrated ability to work independently with minimum supervision .Excellent problem-solving abilities .Excellent communication skills, verbal and written .Applicants selected will be subject to a Public Trust background security investigation and may need to meet eligibility requirements for access to sensitive information .Experience working with Government clients in the health sectors #J-18808-Ljbffr