Company Profile:

INNGEN provides remote IT services to clients around the world. As we work together with some of the world’s most innovative companies at the forefront of business and technology, we help candidates at all levels enhance their skills and potential by recognizing talent and empowering them with new capabilities so that they may go as far as their ambition takes them.

Role Responsibilities:

The Sr Database Administrator is responsible for performing database administration to assure the availability, performance, integrity and security of databases for 1000's of disparate OLTP and Decision Support systems. This individual actively contributes to database architecture and system design. Duties include database support, research, design and implementation of database products that enhance the customer value of Berkley Technology Services databases and products. Also includes project management of our annual database technology stack refresh projects as well as advanced technical and project communications with business units and application teams.

• Responsible for installation, service delivery, and administration of relational database management systems (RDBMS)

• Performs configuration, integration, maintenance, performance management, security management, failure analysis and recovery, and user support of the PROD, UAT, and DEV/INT database environments

• Provide front-line database administration and support for client-facing applications

• Participates in development, maintains, evaluates and documents administration of systems tools and related strategies

• Communicate with application owners through formal correspondence

• Backup/recovery/DR strategy, planning, and execution

• Project Management of annual database stack refresh

• Oversee patch management of RDBMS systems, devising automated methods

• Capacity planning and prediction

• Ensure compliance with all technical specifications and uphold architectural standards

• Responsible for problem escalation to IBM and/or Microsoft Support and third parties as necessary

• Work closely with customer and project team on database design and construction of customer databases

• Diagnose and solve complex problems including non functional problems such as performance issues by identifying workarounds, and driving resolution / "owning" the problem

• Support Key Performance Indicator (KPI) reporting requirements and monitor Service Level Agreement (SLA) compliance. Report regularly on overall performance levels and identify trends.

• Provide off-hours on-call support

• Implementing and managing High Availability and Replication technologies

• Install application upgrades as 2nd Level support for Release Management

Technical Skills Required:

• Working knowledge of UNIX and Windows operating systems

• Strong experience with DB2 on UNIX systems (AIX, Linux), shell programming for automation

• Experience with another RDBMS (SQL Server)

• Experience managing large 500GB+ databases

• Demonstrated ability to effectively manage multiple tasks simultaneously and complete work within allocated time frames

• Self-starter with good ability to work in a team environment

• Strong query tuning and performance problem solving skills (preferred)

• Competent in Unix shell scripting

• Administration support in a multi-customer SOA-based environment with competing demands for your time (preferred)