Unreal Gigs is hiring: Database Administrator (DBA) (The Data Custodian) in San
Unreal Gigs, San Francisco, CA, United States, 94199
Are you passionate about managing data storage, ensuring high availability, and optimizing databases for peak performance? Do you excel at keeping data secure, accessible, and well-organized? If you’re ready to take ownership of a company’s data backbone, our client has the perfect role for you. We’re looking for a Database Administrator (DBA) (aka The Data Custodian) to manage, optimize, and safeguard critical data systems, ensuring smooth operations across the organization.
As a Database Administrator at our client, you’ll work closely with development and IT teams to design, maintain, and support database systems, ensuring they meet business needs. Your role will be key in optimizing performance, managing data security, and ensuring data integrity for mission-critical applications.
Key Responsibilities:
- Manage and Maintain Database Systems: Oversee database environments including installation, configuration, and upgrades of database software. You’ll ensure databases are secure, reliable, and optimized for performance.
- Monitor Database Performance and Tune for Optimization: Continuously monitor database performance, identify bottlenecks, and implement tuning recommendations. You’ll use performance metrics to ensure optimal data retrieval and processing speeds.
- Ensure Data Backup and Recovery: Implement and manage database backup and recovery plans to prevent data loss. You’ll ensure disaster recovery protocols are in place and periodically test recovery procedures for reliability.
- Manage User Access and Data Security: Set up and enforce user roles, permissions, and access controls to maintain data security. You’ll protect databases from unauthorized access and adhere to compliance requirements.
- Perform Data Migration and Integration: Plan and execute data migrations, consolidations, and integrations as needed. You’ll support seamless transitions when new databases or systems are introduced.
- Collaborate on Database Design and Development: Work with developers and data analysts to design and implement efficient database structures. You’ll provide guidance on indexing, query optimization, and schema design for optimal performance.
- Document Database Configurations and Procedures: Maintain detailed documentation of database configurations, troubleshooting steps, and operational procedures. You’ll ensure that knowledge is easily accessible for future maintenance and troubleshooting.
Required Skills:
- Database Management and Tuning: In-depth knowledge of database management, optimization, and tuning techniques for high performance.
- Data Security and Access Control: Familiarity with data security best practices, role-based access control, and compliance requirements.
- Backup and Recovery Management: Proficiency in implementing and managing backup/recovery solutions to ensure data resilience and business continuity.
- SQL and Scripting Proficiency: Strong SQL skills for querying, indexing, and data manipulation. Familiarity with scripting languages (e.g., Python, Bash) for automating database tasks is beneficial.
- Database Systems Knowledge: Expertise in managing relational database systems such as MySQL, PostgreSQL, SQL Server, or Oracle. Familiarity with NoSQL databases (e.g., MongoDB, Cassandra) is a plus.
Educational Requirements:
- Bachelor’s degree in Computer Science, Information Technology, or a related field. Equivalent experience in database administration may be considered.
- Relevant certifications (e.g., Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, AWS Certified Database – Specialty) are advantageous.
Experience Requirements:
- 3+ years of experience in database administration, with a track record of managing and optimizing large-scale databases.
- Experience with monitoring and performance management tools (e.g., SolarWinds DPA, New Relic) is beneficial.
- Familiarity with cloud database solutions (e.g., AWS RDS, Azure SQL Database) is a plus.