Match score not available

Remote - Lead Cloud Hybrid Database Administrator

Remote: 
Full Remote
Contract: 
Salary: 
2 - 145K yearly
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Bachelor’s degree in computer science, engineering or related field, 8+ years of SQL Server and PostgreSQL database administration experience, 2+ years of experience with NoSQL technologies like CosmosDB and MongoDB, Good experience in High availability design and Disaster Recovery, Strong understanding of development methodologies such as Agile and Scrum.

Key responsabilities:

  • Administer on-premises and cloud-based databases using various technologies
  • Design, implement, and maintain high availability and disaster recovery solutions
  • Develop policies for security and integrity of databases
  • Collaborate with IT teams for data integration initiatives
  • Participate in on-call support and address production issues
Green Dot Corporation logo
Green Dot Corporation Financial Services Large https://careers.greendot.com/
1001 - 5000 Employees
See more Green Dot Corporation offers

Job description

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.

Required profile

Experience

Level of experience: Senior (5-10 years)
Industry :
Financial Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Problem Solving
  • Relationship Building
  • Verbal Communication Skills

Related jobs