Senior Database Administrator - Oracle/ Snowflake

Job Description

 

Title - Senior Database Administrator - Oracle/ Snowflake

 

Location - Jacksonville FL

 

Duration – Fulltime

Responsibilities

• The Senior Database Administrator shall be a certified Oracle Snowflake expert with in depth knowledge in large scale Oracle Snowflake implementations.
• Candidate shall administer and maintain the IDR Cloud Snowflake databases in all environments ensuring their optimal performance and security.
• The Senior DBA tasks shall include but are not limited to the following Daily maintenance monitoring performance analysis trouble shooting problem resolution and user assistance required for all the Oracle Snowflake database environments.
• Work with a cross section of internal IT organizations including other DBAs systems analysts developers outside consultants and the management team.
• Participate in Information Technology projects as the primary DBA from inception of the project up and through the daily maintenance phase of a project.
• Provide input into new and existing projects.
• Collaborate with the IDR Modelling team and DBA team regarding optimal clustering and partitioning of data Develop project estimates for database activities
• Responsible for developing and maintaining scripts to create appropriate roles for the application teams implementing Role Based Access Control RBAC and Row and Column Level Security RCLS for the Oracle Snowflake objects
• Participate as Subject Matter Expert SME as required for design reviews and technology and tool selection
• Keep current on database systems and features 3rd party tools and industry standards

Required Skills

• Responsible for the physical design and architecture
• Create monitor and maintain Virtual Data Warehouses supporting various use cases
• Develop database design documentation such as data decompositions and data flow diagrams
• Perform database application and system architecture design
• Create and execute scripts for various database maintenance activities
• Provide guidelines for development and production environments
• Perform database tuning including monitoring troubleshooting and optimizing performance of the databases
• Develop archival backup and recovery strategy Plan perform and monitor database backups
• Perform database recoveries as appropriate Serve as escalation point for database issues.
• Extensive experience with Enterprise Data Warehouses and Data Marts required.
• Capable of supporting and implementing technology projects as the primary DBA in support of business initiatives.
• Ability to create and maintain positive and professional business relationships with both internal associates and external customers.
• Diagnose database problems and implement solutions

Life At Capgemini

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: 

• Flexible work 
• Healthcare including dental, vision, mental health, and well-being programs
• Financial well-being programs such as 401(k) and Employee Share Ownership Plan
• Paid time off and paid holidays 
• Paid parental leave
• Family building benefits like adoption assistance, surrogacy, and cryopreservation
• Social well-being benefits like subsidized back-up child/elder care and tutoring
• Mentoring, coaching and learning programs
• Employee Resource Groups 
• Disaster Relief

About Capgemini

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 360,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group reported in 2022 global revenues of €22 billion.
Get The Future You Want | www.capgemini.com

Disclaimer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibi