Lead database administration for Oracle (19c+) with MS SQL and PostgreSQL support. Design/maintain infrastructure, DR and backup strategies (RMAN), implement security/compliance controls, automate tasks, tune performance, mentor junior DBAs, and provide 24/7 on-call support using monitoring tools like SolarWinds and DataDog.
About Us:
insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data and transform the way finance and data teams operate. We empower leaders from over 32,000 organizations to make timely and intelligent decisions. Our comprehensive solutions span Financial Planning and Analysis (FP&A), Controllership, and Data and Analytics. We deliver finance teams the insights required to navigate any economic climate and drive greater financial intelligence, while increasing productivity, visibility, accuracy, and compliance. Learn more at insightsoftware.com.
Job Description:
Job Description:
We are seeking an experienced Senior Database Administrator (DBA) to join our team. This role requires 10+ years of hands-on experience as an Oracle Administrator and at least 3+ years of experience with MS SQL and PostgreSQL to maintain a reliable, scalable, and fault-tolerant database infrastructure for our growing customer base.
Key Responsibilities:
Database Administration & Support:
- Install, maintain, and troubleshoot RHEL/OEL OS supporting Oracle databases in physical and virtualized environments.
- Provide DBA services to application development, professional services, and support teams, including database design, query validation/execution, and performance tuning.
- Troubleshoot database alerts, logs, jobs, disk groups, tablespaces, and resolve performance-related issues.
- Automate database tasks and develop scripts to improve efficiency and reduce manual intervention.
Infrastructure & Security:
- Lead the design and implementation of database infrastructure solutions to meet business requirements.
- Manage the implementation of technical controls to enforce security policies.
- Ensure compliance with SOC2/ISO27001 audits and adhere to all audited controls.
Backup & Disaster Recovery (DR):
- Design, implement, and maintain DR methodologies, ensuring documentation is up to date.
- Periodically validate Oracle 19c backup/recovery operations using RMAN.
- Assume responsibility for documenting and maintaining disaster recovery plans for each supported system.
Technical Leadership & Mentorship:
- Research, evaluate, design, test, and recommend new database software versions and related tools.
- Act as a mentor for junior DBAs and provide technical guidance.
- Assist development teams in improving database design and PL/SQL best practices.
On-Call & Availability:
- Provide 24/7 on-call rotational support, including occasional weekend coverage.
- Familiarity with monitoring tools like DataDog, Solarwinds, site24/7 or OEM.
Qualifications
- 10+ years of experience with Oracle 19c+ administration.
- 3+ years of experience with MS SQL 2012+ and PostgreSQL.
- Hands-on experience using Solarwinds as a monitoring tool is essential.
- Strong expertise in PL/SQL coding, debugging, and query optimization.
- Proficiency in Linux system administration and bash scripting.
- Experience with Microsoft Azure Cloud, Azure SQL, and PowerShell scripting.
- Strong knowledge of infrastructure design, security best practices, and compliance.
- Experience with high-availability database solutions (clustering, replication, failover strategies).
- Excellent problem-solving and troubleshooting skills.
- Strong communication and collaboration abilities.
- Ability to work independently and as part of a cross-functional team.
Additional Information
All your information will be kept confidential according to EEO guidelines.
Learn more about our high-energy, high-performance global team: Work With Us
insightsoftware About Us: Hear From Our Team
Background checks are required for employment with insightsoftware, where permitted by country, state/province.
At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.
Similar Jobs
Internet of Things • Mobile • Retail
Administers enterprise PostgreSQL, Oracle, SQL Server, and MySQL environments, including installation, upgrades, patching, performance tuning, backup and recovery, replication, high availability, disaster recovery, security, cloud database support, and automation. Provides 24x7 operational support, incident response, vulnerability remediation, configuration hardening, capacity planning, and compliance support across Azure and AWS.
Top Skills:
Amazon Web ServicesBashDatabase Engine Tuning AdvisorDbeaverExplain PlanExtended EventsGgsciGrafanaLinuxAzureMicrosoft Sql ServerMySQLMysql Binary Log ReplicationMysql Enterprise BackupMysql ReplicationMysql WorkbenchMysqldumpOracleOracle Active Data GuardOracle AddmOracle AshOracle AwrOracle Data PumpOracle Enterprise ManagerOracle GoldengateOracle RmanPg_DumpPg_RestorePg_Stat_StatementsPgadminPgbadgerPostgresPostgresql Logical ReplicationPostgresql Streaming ReplicationPowershellPythonShell ScriptingSql ProfilerSql ScriptingSql Server Always OnSql Server Query StoreSql Server ReplicationSql TraceSsmsTkprofToadWindows
Cloud • Information Technology
Manage Oracle and Microsoft SQL Server databases across on-premises and OCI environments. Responsibilities include administration, patching, upgrades, security, performance tuning, backup and recovery, cloning, refreshes, database links, and disaster recovery using Data Guard and SQL Server availability technologies. Conduct DR testing, troubleshoot production incidents, maintain runbooks, collaborate with technical teams, and participate in on-call support.
Top Skills:
Autonomous DatabaseBase Database ServiceExadata Cloud ServiceMicrosoft Sql Server 2016Microsoft Sql Server 2019Microsoft Sql Server 2022Oracle Cloud Infrastructure (Oci)Oracle Data GuardOracle Data PumpOracle Database 11GOracle Database 12COracle Database 19COracle Database 21COracle Database LinksOracle Enterprise ManagerOracle SqlPowershellPythonRmanShellSolarwindsSql Server Always On Availability GroupsSql Server Backup And RestoreSql Server Linked ServersSql Server Log ShippingSql Server MirroringZabbix
Information Technology
Provide end-to-end DBA operations for IBM Db2 UDB and AWS RDS, ensuring high availability, performance tuning, security, backups/DR (HADR/Multi-AZ), monitoring, patching, incident resolution, data masking/archiving, scripting automation, and cost optimization across production and non-production environments.
Top Skills:
AuditingAws CloudwatchAws Enhanced MonitoringAws Performance InsightsAws RdsCross-Region ReplicationDb2 On Ec2EncryptionHadrIamIbm Db2 UdbLinuxMulti-AzMySQLOraclePoint-In-Time RecoveryPostgresPythonRds SnapshotsSecurity GroupsShellUnix
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
