Database Administrator

Dark Horse Tech • Norfolk, VA

6d

About The Position

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.

Requirements

• 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.
• United States Citizenship and Secret Personnel Security Clearance Required

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed