Remote - Lead Cloud Hybrid Database Administrator

What does a Lead Cloud Hybrid Database Administrator do at Green Dot?

Green Dot’s Database Administration team is responsible for developing and enhancing 24x7 enterprise database infrastructure across on-premises and public cloud domains to support the growth of the business and to promote highly available, stable and secure database systems. Reporting to the Director, Database Administration, you will contribute to the overall engineering, design, and high-level support of all existing and new Microsoft SQL Server systems, Microsoft Azure Databases, Azure CosmosDB, Cassandra, DynamoDB, Redis as well as several other data stores managed by the team. As a Lead team member, you will need to work closely with our stakeholders and team members to support day-to-day database administrative activities along with service delivery, incident tracking, performance issues and change management. You will work with all the IT development teams to assist in the implementation, development, deployment and administration of the databases that support the company's IT data integration initiatives. You will have an opportunity to play a crucial role in all projects from inception to completion under the guidance of senior team members.

As Lead Cloud Hybrid Database Administrator, you can look forward to:

• Administering organization’s database infrastructure for on-premises data centers, with main database technology of SQL Server.

• Administering organization’s database infrastructure implemented in public cloud involving technologies such as SQL Server, Azure SQL, Cassandra, CosmosDB, PostgreSQL, and DynamoDB.

• Administering 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.

• Designing & deploying highly transactional database systems using SQL & NoSQL technologies

• Designing, implementing & maintaining multi-region database high availability and disaster recovery solutions

• Developing, implementing, administrating, and maintaining policies and procedures for ensuring the security and integrity of our databases

• Developing automation solutions for database deployment & administration using PowerShell, python, terraform, ansible and other relevant tools

• Design, implementation and maintenance of database solutions, management of data access, and resolving database performance and capacity issues

• Executing design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders

• Designing and manage models using various data modeling tools for SQL as well as NoSQL workloads

• Ensuring physical database features and capabilities are incorporated into data model designs to optimize performance

• Performing problem-solving of application issues and production errors, including high level critical production issues that require immediate attention

• Designing and coding a high volume of SQL queries, stored procedures, and maintain SSIS packages

• Providing technical documentation as needed

• Monitoring and performing performance tuning on stored procedures and ETL jobs

• Analyzing SQL Server production metrics

• Participating in an on-call support rotation and provide non-standard work hour support

Ready to join us in our mission?  These are the qualifications we are looking for:

 Required:

• Bachelor’s degree in computer science, engineering or related field

• 8+ years of in-depth SQL Server & postgreSQL Database architecture and administration experience

• 2+ years of working experience in database development, modeling and administration on NoSQL technologies in CosmosDB , MongoDB, Cassandra etc.

• 1+ years of experience in distributed SQL technologies like CockroachDB, YugaByte etc.

• Good experience in High availability designs, Business Continuity processes, and conducting Disaster Recovery exercises

• Experience of managing SQL Server, CosmosDB, DynamoDB on Azure & 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, the writing of complex stored procedures, optimization for performance and building data pipelines using SSIS & 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.

• Communication and professional skills and the ability to establish relationships across business units.

• Ability to participate in an on-call support rotation and provide non-standard work hour support.

• Financial technology domain knowledge would be a plus

• Experience with T-SQL, SSIS, stored procedures, C#, Javascript, JSon, Powershell, Shell scripting