Database Engineer II

Job not on LinkedIn

November 5

Apply Now

Receive Emails with Similar Jobs

Jonas Software

WebsiteLinkedInAll Job Openings

Enterprise • SaaS • B2B

Jonas Software is a prominent acquirer of vertical market software companies, with a rich history of over 20 years. The company focuses on mission-critical software solutions across various industries, aiming to provide business tools and a network for growth. Jonas Software operates under a decentralized structure, allowing acquired companies to maintain their autonomy while tapping into Jonas's extensive experience and best practices. They adhere to a 'buy & hold forever' strategy, ensuring long-term stability and a permanent home for acquired businesses. With more than 130 successful acquisitions under its belt and being part of Constellation Software, Jonas Software emphasizes preserving the legacy and culture of the companies it acquires, fostering a culture of sharing and leveraging expertise in vertical market software.

1001 - 5000 employees

🏢 Enterprise

☁️ SaaS

🤝 B2B

📋 Description

• 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. • 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. • 24x7x365 on call support on rotation basis.

🎯 Requirements

• Bachelor’s Degree in Computer Science or related field • 8+ years of IT industry experience • 5+ experience in database administration roles in MSSQL, MySQL and Amazon Aurora PostgreSQL • Knowledge and experience of using plan management in PostgreSQL database engine • Very good experience in PostgreSQL database maintenance such as vacuuming, analyzing, and index management • 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 database management, performance tuning and query optimization.

🏖️ Benefits

• Accommodation for a disability during the application process • Equal Opportunity Employer