|
Note: This role is a backfill for a consultant
that is leaving, Jersey City, NJ. 10 year Oracle DBA preferably with some
financial services experience, but not required.
Manager’s Notes
- Go-getter attitude –
wants someone that isn’t afraid to take on additional tasks
- Eager to go in and
learn
- Looking for someone
with a diligent work attitude, following procedures
- Ok with asking for
direction, doesn’t want someone to sit idle
- 5-7+ years’ experience
Position Summary
Database Administrator will define/manage/performance tune
our existing/next generation Oracle databases/database queries/processes and
consolidate multiple stand-alone systems from both distributed and mainframe
computing platforms into an enterprise wide robust, scalable database system
able to meet high performance/thru put/quality standards. . This individual
works with developers to ensure that all technology initiatives are
implemented within the existing or planned framework.
Responsibilities
- Identify
technical opportunities and risks to improve the overall quality and
resiliency of applications in partnership with other development /
Systems leaders
- Evaluating
key technologies and driving thoughtful implementations.
- Establish
and operationalize process to support the adoption and governance of
standard tools and technologies
- Assist
product and technology leadership in making tradeoff decisions on design
approaches and technology selections
- Ensure
technology requirement and challenges are resolved in a consistent and
timely manner
- Works
closely with other business and systems partners to understand and
anticipate efficient and cost effective technologies for business
problems
- Provides
leadership and guidance for database architecture design and development
of high performance messaging, transaction/batch processing products
and/or services by defining and developing database architectures,
detailed designs specifications, development, implementations and
successful delivery of the solution.
- Works
with developers, product managers, and customer application experts to
define solutions, products and modules with required features and
functionality.
- Provides
architectural guidance and leadership on best practices regarding
software/database development, integrations and tools and technologies.
- Works
with the business and systems team to identify the right architecture
for implementing new solutions, products and modules.
- Develops
technology blue-prints for solutions, products and services.
- Design
and develop Proof of Concepts (POCs) to validate suitability and viability
of new technologies and solutions from both functional and technical
perspectives.
- At
times will be hands on development on more complex deliverables.
- Participates
and/or monitors different technology industry standards groups to
maintain strategic relations and represent BBH interests.
- Supports
development and governance of technology and architecture best practices
and the solutions for adoptions.
- Researches,
evaluates new technologies/tools and software products to determine
feasibility and desirability of incorporating their capabilities in line
with the technology strategy of the organization.
- Protectively
researches, evaluates, tests emerging technologies and tools and
presents/documents essential steps to integrate them into
solutions/applications.
- Supports
the systems and business teams for estimates, analysis, design,
development, performance, scalability and benchmark test guidance and
providing subject matter expertise in technology and design.
- Responsible
for measuring and improving the systems - business cross team
relationships
- Working
with the business to ensure that systems response to the business
requirements is appropriate facilitation of business advocacy within
systems
Knowledge and skills (general and technical)
- 10+ years of design
and development of high performance messaging and transaction processing
systems preferably in the financial or telecom industries.
- Strong Oracle database
administration skills with Oracle 10g,11g and 12c databases.
- 10+ years of
experience with SQL Plus, RMAN, UNIX Cron, Perl scripting.
- 8+ years of OLTP and
data warehousing experience with mid and large size databases.
- 8+ years of experience
with Strong Oracle Performance Tuning skills.
- 8+ years of experience
with Oracle PL/SQL.
- Ability to collaborate
with business and technology teams to create practical, robust and
scalable architectures and solutions meeting the business and technology
goals/strategy of the organization.
- 10+ years of
experience with UNIX and Windows operating systems.
- Excellent
communication and presentation skills with ability to communicate at all
levels of the organization.
- Technical leadership
and mentoring skills to guide and act as SME.
- Ability to conduct
code reviews and work with build and automation tools.
- Ability to research
and present results and recommendations.
- Exceptional problem
solving skills
- Keen to learn new
technology with enthusiasm and critical thinking
- All the following
requirements are preferred and a big plus:
- RMAN backups and
restores along with flashback
- Oracle SQL and DB
tuning expert. Well versed in analyzing ASH/AWR/ADDM reports and coming
up with actionable resolutions
- Goldengate
(replication tool) admin and tuning/troubleshooting
- OEM12C - 12C Cloud
Control configuration to monitor databases
- Day to day DBA work -
Monitor the databases logs , backup and space usage, reviewing the AWR
reports to detect pattern/issues in production, critical test databases
- Knowledge of
Exadata/RAC is a big plus
Education level and/or relevant experience(s)
- BS/BA degree in
Engineering and/or Computer Science or related work experience required,
Masters Preferred.
Works closely with application developers, vendors, system
administrators and auditors ensuring best practices for the physical database
design, integrity, performance
|
