SQL Database Administrator

Work Arrangement

Hybrid – 1-2 Days Onsite per Week (Local Candidates Only)

10+years Must

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/DBA 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 week

.We are looking for a strong SQL Server Developer/DBA 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 Git Hub as a revision control system for database scripts

• 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

• 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…