Database Administrator

Position: Database Administrator
Location: Remote 
Contract Length: 12 months + possible extension 
*Must be available to work EST hours 

As a Database Administrator (DBA), you play a crucial role in managing and maintaining databases within an organization to ensure data integrity, availability and security.

1. Database Management Systems (DBMS):

· Proficiency in major DBMS platforms such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or MongoDB.

· Understanding of database architecture and design.

2. SQL Proficiency:

· Strong skills in SQL for querying and managing databases.

· Ability to write complex queries, stored procedures, and triggers.

3. Database Design and Modeling:

· Skills in database schema design and normalization techniques.

· Ability to model data according to business requirements.

4. Performance Tuning and Optimization:

· Experience with performance tuning and optimization techniques for queries, indexes, and database systems.

· Ability to analyze and solve performance bottlenecks.

5. Backup and Recovery:

· Experience with database backup and recovery strategies to ensure data protection and business continuity.

· Familiarity with tools and techniques for disaster recovery.

6. Security Management:

· Understanding of database security practices, including user management, access control, and data encryption.

· Ability to monitor and ensure compliance with security policies.

7. Monitoring and Troubleshooting:

· Ability to set up and use monitoring tools to track database performance.

· Skills in diagnosing and troubleshooting database issues and errors.

8. Automation and Scripting:

· Proficiency in scripting languages like PowerShell, Python, or Bash for automation of routine tasks.

· Familiarity with database automation tools.

9. High Availability and Replication:

· Knowledge of high availability and replication solutions, such as clustering, replication, and data mirroring.

10. Data Integration and ETL:

· Experience with Extract, Transform, Load (ETL) processes for data integration and migration.

11. Capacity Planning:

· Ability to plan and allocate resources effectively to meet future database growth and workload demands.

12. Documentation and Reporting:

· Skills in documenting database configurations, procedures, and policies.

· Ability to generate and analyze reports for database performance and usage.

13. Compliance and Auditing:

· Familiarity with regulatory requirements related to data handling and privacy, such as GDPR or HIPAA.

· Experience with database auditing practices.

14. Soft Skills:

· Strong communication and collaboration skills for working with IT teams and stakeholders.

· Analytical mindset to assess complex situations and make data-driven decision