Systems Engineer IT

**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