Remote - Lead Cloud Hybrid Database Administrator

$95,000 - $145,200/Yr

Green Dot Corporation

Full-time - Mid Level

Remote

Merchant Wholesalers, Nondurable Goods

About the position

As a Lead Cloud Hybrid Database Administrator at Green Dot, you will play a pivotal role in the Database Administration team, which is responsible for developing and enhancing a 24x7 enterprise database infrastructure across both on-premises and public cloud domains. This infrastructure is crucial for supporting the growth of the business and ensuring the stability, security, and availability of our database systems. You will report directly to the Director of Database Administration and will be involved in the engineering, design, and high-level support of various database systems, including Microsoft SQL Server, Microsoft Azure Databases, Azure CosmosDB, Cassandra, DynamoDB, and Redis, among others. In this role, you will collaborate closely with stakeholders and team members to manage day-to-day database administrative activities, service delivery, incident tracking, performance issues, and change management. You will also work alongside IT development teams to assist in the implementation, development, deployment, and administration of databases that support the company's IT data integration initiatives. Your contributions will be vital throughout all project phases, from inception to completion, under the guidance of senior team members. Your responsibilities will include administering the organization's database infrastructure for on-premises data centers, primarily using SQL Server, as well as managing cloud-based databases on platforms like Azure and AWS. You will design and deploy highly transactional database systems, implement high availability and disaster recovery solutions, and develop automation solutions for database deployment and administration using tools such as PowerShell, Python, Terraform, and Ansible. Additionally, you will be responsible for performance tuning, problem-solving application issues, and providing technical documentation as needed. Participation in an on-call support rotation will also be required, along with the ability to provide support during non-standard work hours.

Responsibilities

• Administer the organization's database infrastructure for on-premises data centers, primarily using SQL Server.
• Manage the organization's database infrastructure implemented in public cloud involving technologies such as SQL Server, Azure SQL, Cassandra, CosmosDB, PostgreSQL, and DynamoDB.
• Oversee the organization's cache infrastructure within a hybrid configuration of on-premises and public cloud involving technologies such as NCache, Redis, Elastic Search, and Elastic Cache.
• Design and deploy highly transactional database systems using SQL and NoSQL technologies.
• Implement and maintain multi-region database high availability and disaster recovery solutions.
• Develop, implement, and maintain policies and procedures for ensuring the security and integrity of databases.
• Create automation solutions for database deployment and administration using PowerShell, Python, Terraform, Ansible, and other relevant tools.
• Design, implement, and maintain database solutions, manage data access, and resolve database performance and capacity issues.
• Execute design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders.
• Design and manage models using various data modeling tools for SQL and NoSQL workloads.
• Ensure physical database features and capabilities are incorporated into data model designs to optimize performance.
• Perform problem-solving of application issues and production errors, including high-level critical production issues that require immediate attention.
• Design and code a high volume of SQL queries, stored procedures, and maintain SSIS packages.
• Provide technical documentation as needed.
• Monitor and perform performance tuning on stored procedures and ETL jobs.
• Analyze SQL Server production metrics.
• Participate in an on-call support rotation and provide non-standard work hour support.

Requirements

• Bachelor's degree in computer science, engineering, or related field.
• 8+ years of in-depth SQL Server and PostgreSQL database architecture and administration experience.
• 2+ years of working experience in database development, modeling, and administration on NoSQL technologies such as CosmosDB, MongoDB, and Cassandra.
• 1+ years of experience in distributed SQL technologies like CockroachDB and YugaByte.
• Good experience in high availability designs, business continuity processes, and conducting disaster recovery exercises.
• Experience managing SQL Server, CosmosDB, and DynamoDB on Azure and AWS public cloud platforms.
• Hands-on development experience in SQL Server 2012 and beyond.
• Good experience with database clustering, availability groups, replication, log shipping, and change data capture.
• Extensive knowledge of SQL Server including T-SQL, writing complex stored procedures, optimization for performance, and building data pipelines using SSIS and Azure Data Factory (ADF).
• Strong knowledge and experience in data modeling and relational/NoSQL database design.
• Demonstrated expertise in performance tuning and optimization.
• Good experience with CI/CD processes and scripting languages: Ansible, Jenkins, Redgate, Flyway.
• Good knowledge of SQL administration and monitoring.
• Strong understanding and experience of development methodologies (Agile and Scrum).
• Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
• Strong communication and professional skills with the ability to establish relationships across business units.
• Ability to participate in an on-call support rotation and provide non-standard work hour support.

Nice-to-haves

• Financial technology domain knowledge would be a plus.
• Experience with T-SQL, SSIS, stored procedures, C#, JavaScript, JSON, PowerShell, and Shell scripting.

Benefits

• Competitive salary range of $95,000 to $145,200 per year based on qualifications and expertise.
• Work from Anywhere model promoting remote work flexibility.
• Diversity and inclusion initiatives to create a supportive work environment.
• Reasonable accommodations for candidates on request.