Database Administrator

Job Title: Database Administrator

Location: Fully Remote

Salary: DOE + full benefits

Clearance: Active DHS Suitability (or ability to obtain)

Overview:

TechSur Solutions is a digital services company whose mission is to enable digital transformation for our customers improving quality and efficiency. Based in the DC metropolitan area, TechSur specializes in advanced cloud services, modernization for both IT structures and applications, leveraging Agile development, and Data Analytics. Since we were formed in August of 2016, we have supported multiple impactful and exciting government programs.

Job Responsibilities

· Analyze database requirements of assigned projects.

· Analyze and determine information needs and elements, database relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities.

· Apply knowledge of database management systems to coordinate maintenance and changes to databases.

· Test and implement changes or new database designs.

· Write logical and physical database descriptions, including location, space, access method, and security requirements.

· Provide direction to programmers and analysts as required to affect changes to database management systems. Provide answers to database questions.

· Knowledge of and ability to monitor databases and to analyze and organize data and apply new technology designs and programs.

Required Skills/Work Experience

· 3-5 years of related experience

· Proficiency in database management systems (e.g., Oracle, SQL Server, PostgreSQL, MongoDB).

· Strong knowledge of SQL and database programming.

· Familiarity with data modeling and database design.

· Experience with performance tuning and query optimization.

· Understanding of operating systems (Windows, Linux) and networking.

· Install, configure, and upgrade database management systems (DBMS) such as Oracle, SQL Server, MySQL, PostgreSQL, or MongoDB.

· Set up database environments, including production, testing, and development systems.

· Design and implement database schemas, tables, indexes, and relationships.

· Ensure database architecture aligns with application and business requirements.

· Monitor database performance and identify bottlenecks or slow queries.

· Optimize database configurations, queries, and indexing strategies for efficiency.

· Develop and maintain backup and disaster recovery plans.

· Test recovery processes to ensure data can be restored in case of system failures or corruption.

· Implement and enforce database security measures, including user roles, permissions, and encryption.

· Monitor and address security vulnerabilities to protect sensitive data.

· Diagnose and resolve database-related issues, such as connectivity problems, corrupted data, or performance slowdowns.

· Provide support to application developers, analysts, and end-users.

· Ensure data accuracy and consistency through checks and validations.

· Implement and enforce constraints, such as primary keys and foreign keys, to maintain data integrity.

· Plan for future database capacity requirements, including storage, memory, and processing needs.

· Scale databases to handle growing data volumes and user loads.

· Maintain documentation for database configurations, processes, and procedures.

· Keep records of changes, updates, and maintenance activities.

· Automate routine database tasks, such as backups, indexing, and monitoring, using scripts or tools.

Education

· Bachelor’s degree in computer science, information science, or related field