Position: SQL DBA
Start Date: Immediate
Contract Duration: Long Term, Full-Time hours
Work Location: On-Site in Glen Burnie, MD, remote work will not be considered. Must be available to interview in-person

DK Consulting Overview:
Founded in May 2003, DK Consulting, LLC, a woman-owned small business, was formed to provide management and technology solutions based on industry best practices. DK Consulting, LLC works with multiple State, Federal, and Commercial customers, and our services range from providing customers with that one ‘critical resource’ to assuming responsibility for an entire IT project. We maintain exceptional past performance and provide a personal touch to account management that is rarely seen in the industry today. Some of our awards include:
Requirements:

• Microsoft Certified Database Administrator certification required
• Advanced Structured Query Language (SQL) skills with at least 5 years of writing T-SQL queries.
• 3 years of experience in Database programming, using Stored Procedures, Views, User Defined functions and creating packages using SQL Server Integration Services.
• Must have a minimum of 3 years of experience in the following:
• Installing, configuring, and administering Microsoft SQL Server 2005, 2008 or 2012 Enterprise Editions.
• Designing, implementing and modifying databases with Microsoft SQL Server 2005, 2008 or 2012 Enterprise Editions.
• Using the full analysis capabilities of Microsoft SQL Server 2005, 2008 and 2012 Enterprise Editions.
• Database performance tuning and monitoring.
• Database capacity planning (growth and changes)
• Developing and supporting new databases in response to new business requirements.
• Backing up, restoring and moving databases as dictated by business needs.
• Setting up replication, database mirroring, database mail, database alerts and SQL Agent jobs.

Desirable Skills:

• Providing solutions to implement high availability of SQL Server databases.
• Upgrading SQL Server.
• Maintaining the integrity and security of databases. Security can include defining who can use the database as well as determining who is restricted from accessing one or several of its areas. This includes setting up and removing users, as well as performing database audit tasks.
• Maintaining appropriate and up to date documentation regarding the various databases and environments.
• Performing database reorganization, extent (space management), and rebuilding indexes bases on evaluation of daily database monitoring.
• Monitoring performance and size of SQL databases to proactively identify and fix potential issues and optimize the configuration.
• Creating a Disaster Recovery plan and testing this plan on a regular basis.
• Working with technical and nontechnical staff to understand user and organizational needs, and to develop scalable databases to meet functional requirements.