Jonas Software

Lead Database Engineer

Jonas Software

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇮🇳 India

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSCloudEC2LinuxMySQLPostgresSQL

About the role

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

Requirements

  • Bachelor’s Degree in Computer Science or related field
  • 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.
Benefits
  • Health insurance
  • 401(k) matching
  • Flexible work hours
  • Paid time off
  • Remote work options

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
database administrationperformance tuningdatabase securitycapacity planningtroubleshootingautomationSQLHA/DRPL SQLSSRS
Soft skills
communicationleadershipownershipcollaborationmentoringproactive problem solvingreportingteamworkproject managementinterpersonal skills
Certifications
AWS Certified Professional