Database Administrator

United States Citizenship and Secret Personnel Security Clearance Required

Duties, Tasks & Responsibilities

• Coordinate and Participate in the installation, design, test, maintenance, enhancement, coding, and administration of MSSQL databases.
• Plan, coordinate, and implement security measures to safeguard computer databases and information in computer files against accidental or unauthorized damage, modification, or disclosure
• Managing, monitoring, and administering database system performance and schedules
• Monitoring the performance of system files and managing system data to maintain performance efficiency
• Conducting performance tuning, baselining and forecasting system performance, and managing configurations
• Providing technical support in the evaluation of prime object names, data elements, and other objects
• Recommending appropriate procedure, query, or package changes and optimizations to ensure and improve system performance and reliability
• Installing and configuring database environments including customizing commercial databases to fit specific needs.
• Performing backups, restores, and archiving data
• Participating in server and storage capacity management and planning for the most complex and critical systems
• Recommending and implementing approved process and tool improvements
• Support the development of data model(s) describing data elements and how they are used by following procedures and using pen, template, or computer software.
• Serve as thought leader in identifying and evaluating industry trends in database systems to serve as a source of information and advice for upper management.
• Support the development of data standards, policies, and procedures for Government review.
• Leverage workflow charts to understand tasks computer will perform, such as updating records.
• Perform configuration management, problem management, capacity management, and financial management for databases and data management systems.
• Support the development and execute software system testing and validation procedures, programming, and documentation including user guides procedures, and CMMI/Agile development documentation.
• Utilize commonly used tools such as Python, Microsoft SQL Server, Microsoft Access, and Microsoft VBA to resolve application database issues.
• Analyze users' needs and design, construct, test, and maintain computer applications software or scripts.
• Create and manage user accounts, permissions, and access controls for database systems.
• Troubleshoot and resolve database-related issues, providing timely support to users. Develop and implement disaster recovery plans to minimize downtime in case of failures.
• Perform regular capacity planning to ensure databases can handle growing data volumes.
• Document database configurations, procedures, and troubleshooting steps.
• Provide end-user support on database-related tools and applications.

Required Experience, Skills, & Technologies

• Ten (10) years' experience developing and implementing database maintenance plans ensuring integrity and availability of MSSQL databases.
• Experience developing web tools, using MS.NET, VB.Net and C# programming languages, to be used for the management of SharePoint Portal accounts and other hosted web sites.
• Must be experienced with the development of Java scripts for the optimization of data to aid in the generation of analysis reports on MSSQL server performance.
• SQL developer experience
• Experience with performance tuning, capacity planning, and optimization of database environments
• Strong understanding of high-availability solutions and architecture
• Strong understanding of backup methodologies and their implementation
• Experience developing processes and procedures to standardize database installations and configurations.
• Experience securing databases; applying, remediating and documenting DISA STIGS.
• Strong documentation skills
• Experience automating, scripting, and streamlining processes for efficiency and accuracy.

This position is dependent on contract funding.