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.
