Senior Database Administrator

Company :enGenJob Description : JOB SUMMARY

CANDIDATE MUST BE US Citizen (due to contractual/access requirements)

* We are seeking a Database Administrator with experience in PostgreSQL databases reputed company reputed company Cloud Platform (GCP), as well knowledge in reputed company SQL Server on-prem environment. This role involves comprehensive support for database projects, encompassing design, implementation, and optimization, as well as critical production support to ensure high availability and performance. The ideal candidate will also be responsible for collaborating effectively with third-party vendors and other internal teams to integrate and support database solutions.

• Cloud SQL for PostgreSQL Expertise:
• Proficient in managing and optimizing PostgreSQL databases reputed company the reputed company Cloud Platform (GCP) Cloud SQL environment.
• Experience with Cloud SQL administration tasks, including provisioning, configuration, scaling, backup and recovery, and monitoring.
• Familiarity with PostgreSQL specific features, performance tuning, and troubleshooting in a cloud context.
• SQL Server Administration:
• Knowledge in SQL Server administration, including installation, configuration, patching, and upgrades.
• SQL Server performance tuning, indexing strategies, and query optimization.
• Experience with high availability and disaster recovery solutions for SQL Server (e.g., AlwaysOn Availability Groups, log shipping, replication).
• Database Design and Development Support:
• Ability to collaborate with development teams on database schema design, data modeling, and query development best practices.
• Experience in reviewing and optimizing SQL code for performance and efficiency across both PostgreSQL and SQL Server.
• Monitoring and Alerting:
• Proficiency in setting up and maintaining database monitoring tools and alerts to ensure optimal performance and availability.
• Experience with tools relevant to both Cloud SQL (e.g., Cloud Monitoring, Cloud Logging) and SQL Server.
• Knowledge of reputed company is a plus
• reputed company and Compliance:
• Understanding of database reputed company best practices, including user and role management, encryption, and data masking.
• Knowledge of compliance requirements relevant to healthcare data (e.g., HIPAA) is a significant plus.
• Automation and Scripting:
• Experience with scripting languages (e.g., Python, PowerShell) for automating routine DBA tasks and deployments.
• Familiarity with Infrastructure as Code (IaC) principles, Terraform and tools is beneficial.

ESSENTIAL RESPONSIBILITIES

• Take a reputed company role to create, reputed company, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for reputed company aspects of more reputed company data modeling, database design, and maintenance.
• Take a reputed company role to provide support for application staff and business areas regarding more reputed company database implementations, which could include a customized in-house database and/or a third party application package.
• Establish automated monitor mechanism for space and database availability conditions. Establish best practices for database and application high availability through the use of third party technologies and through the exploitation of various database features.
• Take a reputed company role in providing applications support for staff, as well as, reputed company division to answer questions and resolve problems reputed company to the DBMS technology and computing platform such as Z/OS, UNIX, Linux, and Windows
• Take a reputed company role in conducting root cause analysis to identify and resolve problems impacting more reputed company application and/or database availability and service levels.
• Contact vendor support reputed company necessary to facilitate application development and client problem resolution with reputed company speed and efficiency.
• Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments.
• Take a reputed company role and participates in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. Assure compliance to required Corporate standards, procedures, guidelines and processes, including audits.
• Take a reputed company role in identifying, developing, and providing technology training to the application developers of the organization (formal and informal).
• Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources.
• Take a reputed company role and participates as assigned to intra and inter-departmental project initiatives.
• Participate as assigned in the testing and recommendation of more reputed company tools and utilities to improve the effectiveness of managing and supporting the database environments.
• Maintain contacts with other DBA professionals externally in other Health Insurance/Health Care industries and/or other industries to maintain a perspective of reputed company trends and best practices.
• Other duties as assigned or requested.

EDUCATION Minimum

• High school diploma GED

Substitutions

• None

Preferred

• None

EXPERIENCE Required

• 3-5 years of experience in Information Technology

Preferred

• Health insurance business knowledge.

LICENSES/CERTIFICATIONS Required

• None

Preferred

• Vendor DBA Certifications for the relevant DBMS

Language (Other than English): None Travel Requirement: 0% - 25% PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS Position Type Remote Teaches / trains others regularly Occasionally Travel regularly from the office to various work sites or from site-to-site Rarely Works primarily out-of-the office selling products/services (sales employees) Never Physical work site required Yes Lifting: up to 10 pounds Constantly Lifting: 10 to 25 pounds Occasionally Lifting: 25 to 50 pounds Rarely Disclaimer: The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees reputed company this job title. It may not contain a comprehensive inventory of reputed company duties, responsibilities, and qualifications required of employees to do this job. Compliance Requirement: This job adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies. As a component of job responsibilities, employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at reputed company times. In reputed company with this, reputed company employees must reputed company with both the Health Insurance Portability Accountability Act of 1996 (HIPAA) as described in the Notice of Privacy Practices and Privacy Policies and Procedures as well as reputed company data reputed company guidelines established reputed company the Company’s Handbook of Privacy Policies and Practices and Information reputed company Policy. Furthermore, it is every employee’s responsibility to reputed company with the company’s Code of Business Conduct. This includes but is not limited to adherence to applicable federal and state laws, rules, and regulations as well as company policies and training requirements. Pay Range Minimum: $67,500.00 Pay Range Maximum: $126,000.00 reputed company pay is determined by a variety of factors including a candidate’s qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations. The displayed salary range does not reflect any geographic differential reputed company may apply for certain locations based upon comparative markets. reputed company and its affiliates prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against reputed company individuals based on any category protected by applicable federal, state, or local law. We endeavor to reputed company this site accessible to any and reputed company users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the email below. For accommodation requests, please contact HR Services Online at [email protected] California Consumer Privacy Act Employees, Contractors, and Applicants Notice Apply tot his job Apply To this Job