What are the responsibilities and job description for the Senior Database Administrator position at insightsoftware?
We are seeking an experienced Senior Database Administrator (DBA) to join our team. This role requires 10 years of handson experience as an Oracle Administrator and at least 3 years of experience with MS SQL and PostgreSQL to maintain a reliable scalable and faulttolerant 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 performancerelated 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.
OnCall & Availability :
Provide 24 / 7 oncall 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.
Strong expertise in PL / SQL coding debugging and query optimization.
Handson experience with performance monitoring and tuning tools.
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 highavailability database solutions (clustering replication failover strategies).
Excellent problemsolving and troubleshooting skills.
Strong communication and collaboration abilities.
Ability to work independently and as part of a crossfunctional team.
Additional Information :
All your information will be kept confidential according to EEO guidelines.
Learn more about our highenergy highperformance global team. Work With Us
insightsoftware About Us : Hear From Our Team InsightSoftware (wistia.com)
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.
Learn more about our highenergy highperformance global team. Work With Us
insightsoftware About Us : Hear From Our Team InsightSoftware (wistia.com)
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.
Remote Work : Employment Type :
Fulltime
Key Skills
Databases,SQL,High Availability,PL / SQL,Solaris,Microsoft SQL Server,Database Design,Performance Tuning,MySQL,Shell Scripting,Database Administration,Oracle
Vacancy : 1