Connected Solutions for the Office of the CFO
Senior Database Administrator
Location
India
Posted
19 days ago
Salary
0
Seniority
Senior
Job Description
Senior Database Administrator
insightsoftware
• 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. • 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. • 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. • 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. • Provide 24/7 on-call rotational support, including occasional weekend coverage. • Familiarity with monitoring tools like DataDog, Solarwinds, site24/7 or OEM.
Job Requirements
- 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.
Benefits
- All your information will be kept confidential according to EEO guidelines
- 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.
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Senior Product Manager – Cloud Database, Integrations
DittoReal-time database for mobile, web, IoT, and server apps that can magically sync data with or even without the internet.
• Own the end-to-end product roadmap for Ditto's cloud database • Own the data flow story for Ditto Cloud • Define and maintain customer-facing database SLAs • Own the data migration story • Engage directly with enterprise customers to understand workload patterns • Serve as the go-to voice on the customer data layer inside engineering • Collaborate with GTM and field teams to build enablement assets • Define success metrics for database reliability and drive accountability against them
Role Description We are seeking a highly experienced Senior Oracle Developer & Database Administrator (DBA) to support mission-critical applications and databases. The ideal candidate will possess strong expertise in Oracle database administration, PL/SQL development, production support, performance tuning, database migration, and cloud migration initiatives involving AWS and Red Hat Linux environments. Key Responsibilities - Develop and maintain Oracle PL/SQL packages, procedures, functions, triggers, and database objects. - Provide Level 2/Level 3 production support and resolve critical database issues. - Perform data analysis, troubleshooting, and data correction activities. - Administer Oracle databases including installation, configuration, upgrades, patching, backup, and recovery. - Design, implement, and maintain materialized views and database performance optimization strategies. - Support database migration projects across on-premises, AWS, and Red Hat Linux (RHEL) environments. - Monitor database performance and proactively resolve bottlenecks. - Perform database security, user management, and access control administration. - Execute database deployment, release management, and post-deployment validation. - Collaborate with development, infrastructure, and DevOps teams to ensure system reliability and availability. Qualifications - Strong Oracle Database Administration (DBA) experience. - Advanced PL/SQL development expertise. - Experience with production support and incident management. - Strong SQL performance tuning and query optimization skills. - Experience with materialized views, partitioning, and database performance monitoring. - Hands-on experience with Oracle database migration and upgrade projects. - Experience working with AWS services (RDS, EC2, DMS, S3, CloudWatch). - Experience supporting Oracle databases on Red Hat Enterprise Linux (RHEL). - Knowledge of backup/recovery strategies, RMAN, Data Pump, and disaster recovery. - Strong analytical and troubleshooting skills. Preferred Skills - Oracle RAC and Data Guard. - Shell scripting (Linux/Unix). - DevOps and CI/CD exposure. - Experience in large-scale enterprise production environments. Key Competencies - Oracle DBA - Data Architecture & Engineer - Database Migration - AWS Cloud Migration - Red Hat Linux Administration - Production Support - Data Fixes & Troubleshooting - Materialized Views - Performance Tuning - Backup & Recovery - Root Cause Analysis
Role Description The Connecticut Criminal Justice Information System (CJIS-CT) is expanding its CISS Analytics platform, designed to improve data sharing and analytics across criminal justice agencies. The system supports policy and legislative decisions related to crime and public safety. CJIS is seeking a SQL Database Developer/Administrator to support database development, performance optimization, and data transformation efforts while collaborating with business teams, infrastructure teams, and analytics stakeholders. Key Responsibilities - Design and review database schemas for application releases - Perform database maintenance (index rebuilds, table reorganization) - Support day-to-day database operations and troubleshooting - Optimize database performance and query efficiency - Assist with database upgrades and migration strategies - Administer multiple SQL Server databases across environments - Develop views, stored procedures, triggers, and functions - Work with Microsoft BI stack (SSRS, SSIS, SSAS) - Develop dashboards and reports using Power BI - Support ETL processes and data transformation - Participate in unit testing and assist with system/UAT testing - Ensure compliance with CJIS architecture standards including JRA, NIEM, NCSC, and GFIPM Qualifications - 5+ years experience with: - Microsoft SQL Server 2019/2022 (Development & Administration) - SSRS, SSIS, SSAS - ETL processes - Power BI dashboards - Writing Views, Triggers, Stored Procedures, Functions - Database performance tuning (indexes, constraints, keys) - Windows Server 2019/2022 - PowerShell or Windows shell scripting Nice to Have - Database design tools such as ERWIN or Embarcadero - RUP / structured development methodology - CONNX ETL tool - Disaster Recovery / Business Continuity Planning Additional Requirements - Ability to work in a 24x7 on-call support environment if required - Must pass background investigation - Work collaboratively with criminal justice agencies and state partners
Role Description The Database Design and Data Management professional is responsible for designing, implementing, maintaining, and analyzing enterprise databases to ensure data integrity, accessibility, and performance across multiple applications. - Design logical and physical database structures. - Develop, implement, and maintain enterprise and workgroup databases. - Develop stored procedures and optimize database performance. - Perform database backups, recovery, and performance tuning. - Conduct data integration, mapping, and validation. - Collect, organize, and analyze datasets using statistical methods and machine learning tools. - Develop data visualization tools and analytical models to support decision-making. Qualifications - Bachelor's degree from an accredited four-year college or university. - Preferred coursework in Computer Science, Data Science, Information Systems, or Database management. Requirements - Minimum 2 years of full-time paid experience in database design, administration, data analysis, or data management. - Experience with enterprise data systems and distributed information systems.


