Lead - Oracle DBA

<strong>At CNSI, we strive to be the market leader and most trusted partner for innovative and transformative technology-enabled solutions that improve health outcomes and reduce costs. We&rsquo;re passionate about helping our clients improve the health and well-being of individuals and families. We succeed when our clients succeed.</strong>

Hybrid/Remote

CNSI-India

<strong>CNSI delivers a broad range of health information technology enterprise solutions and customizable products to a diverse base of state and federal agencies. We align, build, and manage innovative, high-quality, cost-effective solutions that help customers achieve their mission, enhance business performance, reduce costs, and improve health for over 50 million Americans.</strong> https://www.cns-inc.com/

keywords: job brief,database,develop,analysis,technical,teamwork,leadership,organization,experience,knowledge,database,communication,degree,technology,proficiency,cloud,skills,license

Full Time

Overview: <div class="alert alert-info"> <p>This position is responsible for managing the day-to-day functioning of the department. The Role and responsibilities of this position include: Should have worked on at least 1 to2 migration programs. Strong in Database technologies like Oracle RAC, DB rep.</p> </div>
Responsibilities: <ul> <li>Develop database solutions in the areas on both the system side and application side as well as design/ implement databases in the cloud.</li> <li>Works with customers on presenting business/ technical solutions for complex business functionalities.</li> <li>Demonstrates leadership skills and proven ability to work effectively with different teams directly and in a matrix environment.</li> <li>Acts as the primary Database Administration expert.</li> <li>Serves as the subject matter expert and works collaboratively with a team of SMEs, senior software architects, and developers to implement solutions.</li> <li>Evaluate new solutions and technologies in the areas of Database and security-related products.</li> <li>Participates in logical and physical database designs.</li> <li>Interfaces with stakeholders to understand an organization&rsquo;s data needs.</li> <li>Keeps abreast of IT industry trends and developments to help identify potential new technologies for the improvement of Academy&rsquo;s systems infrastructure.</li> <li>Designs develop and enforce standards and architecture for all data needs within the organization</li> <li>Designs develop and enforce standards, and architecture for installing, configuring, and using databases and database-related products.</li> <li>Demonstrates in-depth knowledge of database administration to ensure high quality.</li> <li>Demonstrates advanced expertise and contributes to the Database Administration practice by publishing technology points of view through the creation of white papers and facilitation of workshops.</li> </ul>
Requirements: <p class="Default"><strong><u>Who you are:</u></strong></p> <ul> <li>Bachelor&rsquo;s Degree with 1-5 years of experience in the industry or in previous management positions.</li> <li>8-10 years as lead on projects.</li> <li>Industry-specific licenses and certificates may be preferred</li> <li>Proven leadership skills with a history of effective management.</li> <li>Self-motivated and detail-oriented, with notable experience handling multiple projects and tasks.</li> <li>Strong interpersonal and communication skills, with a proven ability to positively interact with staff and clients.</li> <li>Willingness to work extended hours and be on-call for other duties, as needed.</li> <li>Understanding of the Software Development Lifecycle (SDLC) and Software Testing Lifecycle (STLC).</li> <li>Proficient in Oracle Database features and functionalities; Excellent hands-on in handling DB Upgrades &ndash; Oracle 12c to Oracle 19c.</li> <li>Preferred Oracle database administration working experience on AWS and Oracle cloud platforms. Experience in Oracle 10g/ 11g/ 12c environments.</li> <li>Experience in 10G/ 11G RAC, ASM, OEM 11g/ 12c, RMAN, Data Guard, Flashback technology, DB upgrades, DB patching</li> <li>Expert in implementing DR Solutions (Data Guard, Golden Gate).</li> <li>Expert in implementing containerization methodology.</li> <li>Knowledge of Health Insurance products and services.</li> <li>Willingness to learn new Technology and Challenges.</li> <li>Experience in Production/ Technical/ Operations Support.</li> <li>Knowledge of the business goals, objectives, and business operations for the appropriate FIS organization.</li> <li>Strong replication experience (Data Guard, Golden Gate), in addition to backup and recovery (RMAN).</li> <li>Expert in implementing Database Security Products like Oracle TDE, Oracle Data Masking, Oracle Database Vault, Oracle Audit Vault, OCM, RMAN Encryption, etc.</li> <li>Workload isolation in the cloud &amp; Automatic indexing; well versed in configuring CDB and PDB.</li> <li>Strong knowledge in Backup &amp; Recovery (RMAN) and DB Monitoring (OEM) Technologies</li> <li>Moderate to Expert Level Experience in Performance Tuning techniques (Tuning PL/ SQL code/ Databases/ Application Code, AWR, ADDM, ASH, Profiler, TFA, etc.)</li> <li>Proficiency in basic SQL and Database Tuning.</li> <li>Working knowledge of Engineered Systems like Oracle SuperCluster, Exadata is preferable.</li> <li>Experience in working with Database Security Solutions like Encryption-At-Rest, Encryption-In-Flight, Audit Monitoring, etc.</li> <li>Strong troubleshooting skills</li> <li>Knowledge of Microsoft Word, Excel, and Visio, with a working knowledge of the rest of the Microsoft Office suite of applications.</li> <li>Domain knowledge of Medicare, Medicaid, and/ or healthcare verticals is preferable.</li> <li>Preferred working experience of coordinating with offsite teams out of India.</li> <li>Shows initiative, enthusiasm, creativity, and resourcefulness in handling assignments.</li> <li>Demonstrates flexibility in working under the demands and needs of the project.</li> <li>Strong analytical and problem-solving skills and attention to detail.</li> <li>Willingness to support production databases in a high-quality and dynamic environment.</li> <li>High level of expertise in parallel operations and parallel executions.</li> <li>Excellent written and verbal communication skills.</li> <li>Ability to communicate with all levels of management and across functional lines.</li> <li>Ability to understand business needs, analyze processes, and develop alternative solutions.</li> <li>Oracle Certified Associate or Professional Certification is preferred.</li> </ul>