Database Admin Sr. Advisor

OverviewAt One Identity we know that companies with a strong positive culture perform so much better That is why every day we strive to create a collaborative and inclusive working environment where our people can feel empowered to succeed One Identity is an award-winning IT management software provider offering a broad selection of solutions that solve some of the most common and most challenging IT problems We are looking for a talented and experienced Database Administrator DBA to join our engineering team As a DBA supporting you will be responsible for the performance reliability and scalability of our database systems particularly PostgreSQL which is central to our data architecture This role will involve administering large-scale PostgreSQL databases optimizing performance ensuring high availability and providing support for database migrations backups and disaster recovery You will collaborate closely with developers DevOps and other technical teams to ensure the smooth operation of our critical systems and data pipelines If you are passionate about database management enjoy solving complex problems and want to contribute to an innovative and fast-growing SaaS company we d love to hear from you Responsibilities-Manage maintain and optimize PostgreSQL databases in production test and development environments-Ensure high availability reliability and scalability of databases-Implement and maintain automated database monitoring backups and performance-tuning processes-Troubleshoot and resolve database issues related to performance capacity and availability-Perform proactive performance analysis and tuning of queries indexes and schema design to ensure optimal database performance-Design and implement database partitioning indexing and optimization strategies for large-scale datasets-Continuously monitor database performance and make recommendations for improvements to system and query efficiency-Implement and enforce database security policies and best practices including encryption access control and user management-Work with security and compliance teams to ensure databases meet regulatory standards e g GDPR SOC 2 etc -Maintain database disaster recovery plans and backup strategies perform regular database backups and ensure quick recovery in the event of failure-Provide on-call support and troubleshooting for production database issues-Assist in the migration of databases to new environments patching to maintain database integrity and security and upgrading PostgreSQL versions as necessary-Work closely with development Quality Assurance DevOps and other teams to support application deployments infrastructure changes and strategic initiativesQualifications8 years of hands-on experience as a PostgreSQL Database Administrator or in a similar database management role-Expertise in PostgreSQL database architecture performance tuning and query optimization -Experience with high-availability setups replication failover and disaster recovery strategies in PostgreSQL -Strong understanding of database security backup recovery strategies and data integrity principles -Familiarity with cloud-based databases AWS Aurora RDS -Experience with database migration and version upgrade strategies -Proficiency with Linux Unix-based systems and shell scripting -Excellent problem-solving skills and the ability to troubleshoot complex issues effectively under pressure-Good team collaboration skills with a pragmatic and positive attitude-Excellent written and verbal communication skills in EnglishNice-to-have-Bachelors degree in a technology related field or equivalent work experience-Familiarity with other database systems like MySQL MariaDB and or NoSQL databases such as DynamoDB and Redis-Experience with monitoring tools e g Datadog CloudHealth Sumologic and PostgreSQL extensions e g pg stat statements pg partman is a plus -Experience with infrastructure as code IaC tools such as Terraform CloudFormation Puppet and managing code via a Git version control system-AWS certifications such as AWS Certified Database Specialty or AWS Certified Solutions Architect AWS Certified Cloud Practitioner-Exposure to continuous integration continuous deployment CI CD pipelines and database script execution tools like LiquibaseCompany DescriptionOne Identity enables organizations of all sizes to better secure manage monitor protect and analyze information and infrastructure to help fuel innovation and drive their businesses forward With team members around the globe we intend to continue to grow revenues and add value to customers When you join our team you will have the opportunity to build and develop products at a scale few others can provide Our product portfolio serves a large base of customers and we are addressing the strategic imperatives for enterprise businesses Working with some of the most talented employees the industry has to offer we provide enhanced career opportunities for team members to learn and grow in a rapidly changing environment Why work with us-Life at One Identity means collaborating with dedicated professionals with a passion for technology -When we see something that could be improved we get to work inventing the solution -Our people demonstrate our winning culture through positive and meaningful relationships -We invest in our people and offer a series of programs that enables them to pursue a career that fulfills their potential -Our team members health and wellness is our priority as well as rewarding them for their hard work One Identity is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind One Identity is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment All employment decisions at One Identity are based on business needs job requirements and individual qualifications without regard to race color religion or belief national social or ethnic origin sex including pregnancy age physical mental or sensory disability HIV Status sexual orientation gender identity and or expression marital civil union or domestic partnership status past or present military service family medical history or genetic information family or parental status or any other status protected by the laws or regulations in the locations where we operate One Identity will not tolerate discrimination or harassment based on any of these characteristics One Identity encourages applicants of all ages Come join us For more information visit us on the web atJob seekers should be aware of fraudulent job offers from online scammers and only apply to roles listed on quest com careers using our applicant system Note We do not use text messaging or third-party messaging apps like Telegram to communicate with applicants so please exercise caution if you are approached in this way and only interact with people claiming to be Quest employees if they have an email address ending in quest com or oneidentity com LI-SR1