Senior Database Administrator

Summary

Join insightsoftware as a Senior Database Administrator and leverage your 7+ years of MS SQL and 3+ years of Oracle and PostgreSQL experience. You will maintain a reliable, fault-tolerant database infrastructure across global environments. Key responsibilities include database installation, patching, and maintenance, providing DBA services to various teams, and managing backups and recovery. You will also be involved in planning new database software implementations and ensuring database security. The role requires strong hands-on experience with specific database systems and related technologies, along with experience in coding, debugging, and tuning. A commitment to maintaining high customer satisfaction and working in a fast-paced environment is essential.

Requirements

• Strong hands-on experience with Microsoft SQL 2012+ and Oracle 12+ is required
• Practical experience in coding, debugging and tuning Oracle PL/SQL and SQL is required
• Knowledge database management, performance monitoring and performance tuning tools is required
• Knowledge of Linux system administration and bash scripting is required
• Ability to work in a rapidly evolving environment, effectively multi-task and balance multiple priorities while maintaining a high level of customer satisfaction is required

Responsibilities

• Install, patch and maintain all Microsoft SQL Server, Oracle and PostgreSQL databases
• Provide DBA services to application development, professional services and support teams, including day to day operation, query validation and execution, database design, database generation, coding, and performance related issues
• Be instrumental in researching, evaluating, designing, testing, recommending, and planning implementation of new versions or database software and database related tools
• Manage regularly scheduled backups and refreshes
• Manage database backup and recovery
• Tune database components
• Create necessary automation for DB operations using Bash and PowerShell
• Manage the implementation of technical controls to support and enforce defined security policies
• Assume responsibility for documenting and maintaining disaster recovery plans for each supported system/application
• Actively participate in SOC2/ISO27001 audits and ensure all audited controls are adhered to
• Provide 24/7 on-call rotational duty and some week-ends

Preferred Qualifications

• Knowledge of PostgreSQL is strongly preferred
• Experience with MS Azure Cloud, PowerShell scripting, Azure SQL is strongly preferred
• Experience with managing multi-tenant SaaS applications is strongly preferred
• Relevant professional certifications are preferred, but not required