Lead Database Engineer

Database Operations Group Position

Qualified candidates are being considered for openings within the Database Operations group at C&R Software, Fairfax, VA. These candidates will possess a strong background in SQL Server, MySQL and PostgreSQL database management and administration. The individual will partner with product support, and DevOps CSM to keep databases secured, healthy and up to date to meet SLAs.

The position is part of the Database Operations group which focuses on managing, maintaining, and securing databases in the AWS Cloud. This position requires an extensive experience with MSSQL, MySQL, and PostgreSQL and experience with AWS Cloud services. The candidate is expected to manage SQL Server, MySQL, and PostgreSQL databases in the cloud. The candidate should be responsible to manage and maintain databases in AWS Cloud. The candidate should have a solid understanding of RDS cluster, taking snapshot of RDS instance, monitor database performance issues and resolve them, and participate in On-Call rotation as needed. Previous experience within Banking and Financial Services is preferred.

This position is based in India. This is a remote position.

This is 8am to 5 pm EST shift.

Key Responsibilities

• Install, upgrade, and manage database servers and schemas.
• Set and maintain enterprise database standards.
• Manage database access and Develop processes for optimizing database security.
• Performance tuning of database systems particularly RDS/Aurora PostgreSQL and MySQL.
• Create database backups and restore database from backups.
• Plan capacity for database servers.
• Diagnose and troubleshoot database errors.
• Create and manage database reports, visualizations, and dashboards.
• Automate repeating database tasks.
• Be available for on-call support.
• Experience as a DBA with AWS Cloud databases MSSQL, Aurora/RDS PostgreSQL and MySQL.
• Monitor database incidents queue and act based on priority.
• Implement and deploy database changes in Prod and QA environments.
• Monitor MSSQL, MySQL, and PostgreSQL database performance issues and resolve them.
• Interact with other DBA team members, product support team, and DevOps CSM and keep them aware of critical issues at hand.
• onsite team member to understand project requirements and goals.
• Report progress status to team manager various database support tickets and other projects.
• Manage, maintain, and secure RDS Aurora PostgreSQL, MySQL and MSSQL databases.
• Understand the PL SQL scripts provided in the change and be able to make a call if scripts are not well performant or not correct.
• Troubleshoot and resolve SSRS issues.
• Proactive and take ownership of highly visible issues and projects.
• Establish partnership with other teams and drive projects.
• Able to provide database level technical leadership and mentor junior DBAs.
• Establish database support standards to help in the areas of database support with minimal interruptions.

Job Requirements:

• Bachelor's Degree in Computer Science or related field.
• This is Mid-Senior level Database Engineer.
• 12+ years of IT industry experience.
• 10+ experience in database administration roles in MSSQL, MySQL and Amazon Aurora PostgreSQL.
• Experience with Linux and Windows Server environments.
• Extensive experience with database technologies (MySQL, MSSQL, PostgreSQL).
• Experience with AWS cloud services.
• Experience with cloud database infrastructure management and administration.
• Extensive experience in HA/DR in major enterprise database systems.
• Experience in SQL Server Reporting Services.
• Good communication skills including verbal and writing skills
• Experience in either the Banking or Financial Industry is preferred
• Preferred AWS certified professional who has experience in RDS, IAM, EC2, VPC and Storage
• Experience in troubleshooting performance issues from infrastructure and database engine.
• Experience working with clients and other department leads within the organization.
• Must have AWS and Aurora PostgreSQL experience.

Competencies:

Action Oriented, Customer Focus, Technical Skills, Problem Solving, Personal Learning

Business Unit:

Jonas Collections and Recovery - India

Scheduled Weekly Hours:

40

Number of Openings Available:

1

Worker Type:

Regular

More About Jonas Software:

Jonas Software is a leading provider of enterprise management software solutions, serving a wide range of vertical markets including hospitality, healthcare, construction, education, personal care, fitness, leisure, moving and legal services, to name a few. Within these markets, Jonas is comprised of over 65 distinct brands, each a respected leader in its domain.

Jonas' vision is to be the branded global leader across these verticals and to be recognized by customers and industry stakeholders as the trusted provider of "Software for Life." We are committed to technology, product innovation, quality, and exceptional customer service.

Jonas Software supports over 60,000 customers in more than 30 countries. We employ over 6,000 skilled professionals, including industry experts and technology specialists. Across our broader network, we support a global workforce of more than 30,000 employees.

Headquartered in Canada, Jonas Software has a global footprint with offices around the world. We're a 100% owned subsidiary of Constellation Software Inc., based in Toronto, publicly listed on the TSX (CSU.TO), and a member of the S&P/TSX 60 Index.