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

This position is dependent on contract funding.