OppenheimerFunds Distributor, Inc
OFI is seeking a Lead Oracle Server DBA to join our team.
This candidate will have full life cycle responsibilities for Oracle Server and other database technologies.
You will demonstrate your technical expertise while exhibiting outstanding customer service skills.
This individual will be a critical partner to our Product Development, DevOps and Cloud Engineering teams.
Work closely with DevOps and Cloud teams to support various design, automation and cloud migration initiatives.
Champion and support cloud database solutions.
Act as a technical lead for a team of DBAs being the primary point in driving standard processes, troubleshooting methodologies and setting the tone for excellence.
Build positive relationships with internal and external customers/business users by providing excellent service/support and consistent communication.
Assist project teams with technical issues in all phases of a projects life cycle. This includes providing technical analysis / design services to the project through the delivery of recommended design.
Strong knowledge of indexes, index management, statistics, integrity checks, configuration, and patching.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc.,
Ability to write, troubleshoot and optimize scripts for maintenance and health checks.
Create and optimize database objects (stored procedures, functions, tables, views, triggers, indexes, constraints).
Proactively recommend and implement improvements to systems and processes.
Create and maintain database documentation, standards and policies.
Oracle Server configuration, including the installation and validation of security patches.
Collaborate with development team regarding database related development such as ETL, Data Warehousing and Database Design.
Backup and Recovery - Ensure backups are functioning and that recovery processes are documented and tested regularly.
Design/manage solutions to meet High Availability and DR requirements. Support DR initiatives.
Process automation and scripting.
Train and provide guidance to offshore L2 team members to perform day-to-day operations tasks ensuring the availability, reliability and security of our solutions. Mentor L2 teams to effectively complete operational tasks and assist with projects when appropriate.
8 years of Oracle Server experience – 10g through current version
2 years technical lead experience
Knowledge of Oracle Server Tools (OEM, Toad, ASH, AWR, SQL Diagnostics and Tuning pack,
and native SQL to troubleshoot and performance tune)
Skilled in backups & disaster recovery
Advanced knowledge of Oracle Exadata
Collaborative and strong communication skills
Open to new ideas, capabilities and technologies
Excellent analytical and problem solving skills, anticipates issues and deals with them proactively (Critical Thinking)
Sound judgment and personal integrity
Comfortable in an environment with flexible work schedules, 24/7 availability, and on-call rotation
Preferred Technical Knowledge:
PostgreSQL, Aurora, MySQL, Vertica, Mongo and/or SQL
Experience migrating applications/databases to AWS
Reporting server and analytical server
Experience working in an environment with Informatica and/or Cognos
ETL and database migration experience
We are a dynamic firm that values teamwork and collaboration, and true to our history, we encourage independent thinking and provide ample opportunities for our people to stand out and make a difference. With offices in New York, Denver, Rochester and Dallas, we work hard to turn our unconventional wisdom into value for investors and pursue excellent results for ourselves and our firm. Learn more about the culture and opportunities at OppenheimerFunds here:
OppenheimerFunds and its subsidiaries and affiliates provide equal employment opportunity to all qualified individuals without regard to age, color, disability, gender, marital status, national origin, race, religion, sexual orientation, gender identity and expression, physical or mental disability, genetic predisposition or carrier status, veteran status, or any other characteristic protected by law in all employment functions including recruitment, evaluation, selection, promotion, compensation, benefits, training, and termination of employment.
Note that this posting is intended for individual applicants. #LI-VV1
You may click here
to apply for this job at SmartRecruiters.
View More OppenheimerFunds Jobs
OppenheimerFunds Distributor, Inc
Website : http://www.oppenheimerfunds.com
Founded in 1959, the firm has a proven track record of identifying rewarding opportunities for clients by following these four principles that make up The Right Way to Invest: make global connections, look to the long term, take intelligent risks and invest with experience. The firm’s investment staff comprises 17 independent but collaborative teams that specialize in equity, fixed income, alternatives and multi-asset investment strategies, and smart beta solutions.. OppenheimerFunds and its subsidiaries offer an array of investment products and services. The firm provides advisory services to the Oppenheimer mutual funds, and its OFI Global Asset Management subsidiary offers investment solutions to institutional clients. For more information, visit www.oppenheimerfunds.com.