Tech Stack
ETLMongoDBMS SQL ServerMySQLOraclePostgresPythonSQL
About the role
- 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.
- Must be available to work EST hours.
- Contract Length: 10+ months.
Requirements
- Proficiency in major DBMS platforms such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or MongoDB.
- Understanding of database architecture and design.
- Strong skills in SQL for querying and managing databases.
- Ability to write complex queries, stored procedures, and triggers.
- Skills in database schema design and normalization techniques.
- Ability to model data according to business requirements.
- Experience with performance tuning and optimization techniques for queries, indexes, and database systems.
- Ability to analyze and solve performance bottlenecks.
- Experience with database backup and recovery strategies to ensure data protection and business continuity.
- Familiarity with tools and techniques for disaster recovery.
- Understanding of database security practices, including user management, access control, and data encryption.
- Ability to monitor and ensure compliance with security policies.
- Ability to set up and use monitoring tools to track database performance.
- Skills in diagnosing and troubleshooting database issues and errors.
- Proficiency in scripting languages like PowerShell, Python, or Bash for automation of routine tasks.
- Familiarity with database automation tools.
- Knowledge of high availability and replication solutions, such as clustering, replication, and data mirroring.
- Experience with Extract, Transform, Load (ETL) processes for data integration and migration.
- Ability to plan and allocate resources effectively to meet future database growth and workload demands.
- Skills in documenting database configurations, procedures, and policies.
- Ability to generate and analyze reports for database performance and usage.
- Familiarity with regulatory requirements related to data handling and privacy, such as GDPR or HIPAA.
- Experience with database auditing practices.
- Strong communication and collaboration skills for working with IT teams and stakeholders.
- Analytical mindset to assess complex situations and make data-driven decision