*summary*
*responsibilities*
manage database solution design to support portfolio/project/architectural cycles
- develop and maintain an operations model to centralize and optimize practices
- establish, manage and optimize a dba tools roadmap
- integrate into the lifecycle of portfolio delivery as it relates to executing a project and operationalizing it for ongoing support
- manage and maintain operational efficiencies within the dba team to deliver on key metrics that enable corporate initiatives and service delivery
- ensure proper synergies to deliver on time-sensitive initiatives under the project management methodology in place (on time, within the quality specs, and within budget)
- create, develop, 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.
- perform proactive analysis of database infrastructure capacity and performance
- evaluate new technologies to improve service reliability, performance, and efficiency
- ensure proper implementation of large scale rdbms environments
- analyze and propose alternative approaches for data development solutions
- monitor and refine processes, procedures, and systems to optimize effectiveness and integrity and recommends and implements improvements
- ensure proper documentation for database and data model design
- provide after-hours and weekend support as required for on-call responsibilities, database refreshes, testing, technology upgrades, and other off-hour assignments.
- participate in staff training opportunities (formal and informal) about rules, procedures, and standards for accessing and maintaining shared data resources.
- participate as assigned to intra and inter-departmental project initiatives.
- participate in rdbms performance and tuning and rdbms utilities—capacity planning for various rdbms and performing tuning for multiple rdbms activities.
- participate as assigned in the testing and recommending tools and utilities to improve managing and supporting the database environments.
*requirements*
- bachelor's degree in computer or electrical engineering, computer science, mathematics, or a related field required
- minimum of 7 years database administration experience with administering and supporting multiple rdbms databases for performance-critical, highly available systems on the unix/linux platform
- experience in various rdbms architecture, configuration, administration, and directory services
- minimum of 5 years of data modeling experience with conducting performance tuning, backup/recovery, and scalability/capacity planning, in addition to sql, pl/sql, and scripting
- detailed understanding & experience of linux operating systems and shell scripting
- experience in enterprise replication concepts and tools (golden gate, streams, shareplex, active data guard)
- require excellent troubleshooting and problem-solving abilities.
- experience with backup/restore functionality using rman, ddboost, data domain, and recovery manager
- experience creating automation tools for managing relational databases (auditing, account management, backup/restore, discovery, schema deployment).
- experience managing servers in large-scale, geographically diverse environments.
- excellent performance tuning skills (awr, tracing, explain plans, sql, and instance tuning, profiler)
- experience in a consultancy role, assisting and mentoring junior dba staff.
- this position requires 24/7 operational support on a weekly rotation.
- itil v3 foundation certification
*preferred qualifications*:
- experience with oracle, mysql, and postgres databases
- itil training and certification