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