Work Remotely from Anywhere - U.S., USA
64 days ago
Remote - Lead Cloud Hybrid Database Administrator

We’re looking for talented professionals, anywhere in the United States, to join us in bringing smart money management and payment solutions to everyone’s fingertips.

At Green Dot, we are evolving to a new and permanent “Work from Anywhere” model designed to maximize the benefits of remote work, promote and enable a strong culture of performance and connectedness, and attract the best and brightest talent who align with our entrepreneurial spirit and mission.

<<>><<>><<>><<>><<>><<>><<>><<>><<>><<>> 

JOB DESCRIPTION

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

POSITION TYPE

Regular

PAY RANGE

The targeted base salary for this position is $95,000 to $145,200 per year. The final compensation will be determined by a number of factors such as qualifications, expertise, and the candidate’s geographical location.

<<>><<>><<>><<>><<>><<>><<>><<>><<>><<>>

Green Dot promotes diversity and provides equal opportunity for all applicants and employees. We are dedicated to building a company that represents a variety of backgrounds, perspectives, and skills. We believe that the more inclusive we are, the better our work (and work environment) will be for everyone. Additionally, Green Dot provides reasonable accommodations for candidates on request and respects applicants' privacy rights.

Confirm your E-mail: Send Email