Part of the IT Operations team, the Database Administrator role is largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, resolving incidents within SLAs, reviewing service related reports (e.g. database backups, maintenance, monitoring) on a daily basis to identify and minimize service related issues, responding to database related alerts and escalations and working with external engineers where necessary to come up with strategic solutions to recurring problems. The role is also responsible for analyzing, developing and maintaining organizational reporting, both business as usual and new reporting requirements as they arise through marketing and/or project activity. A good understanding of, or desire to learn, Virtual Server concepts (VMWare and Microsoft Windows Server), troubleshooting and management as pertains to the larger infrastructure would form a portion of the role.
**Critical Tasks and Expected Contributions / Results**
+ Keep SQL and Oracle databases up-to-date, including testing, patching, upgrades and migrations;
+ Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements;
+ Manage database security/integrity and backup procedures;
+ Manage database access with supporting auditable processes and documentation;
+ Design and implement maintenance procedures;
+ Ensure that databases and reporting meets user requirements;
+ Ensure processes and deliverables are documented;
+ Develop and maintain ETL processes, including data warehouse procedures;
+ Test and modify databases to ensure that they operate reliably;
+ Implement and test disaster recovery plans;
+ Database hygiene, including archiving data and capacity planning;
+ Take the lead on the database components of projects and help to identify and initiate database related projects;
+ Liaise with programmers, applications/operational staff, IT project managers and other technical staff;
+ Define data objectives through consultation with staff at all levels;
+ Take a proactive role in helping to review and define the data architecture of Cigna’s systems;
+ Contribute to team efforts by accomplishing related duties as needed.
**Experience/ Education /Knowledge Requirements:**
+ At least 2 years’ experience with database administration for MSSQL Server;
+ At least 2 years’ experience with database administration for Oracle 11g;
+ Experience with Microsoft Server Operating systems 2008 to 2016;
+ Experience with VMWare; building, maintaining virtual machines;
+ Development experience with SSIS and Business Objects highly advantageous;
+ Active involvement in DBA community, forums or newsgroups;
+ Certification in MSSQL or Oracle would be an advantage;
+ Strong knowledge of index management, how indexes are stored, how they can be created and managed effectively;
+ Strong knowledge of how statistics work and how to use them for effective management.
**Role Competency Requirements:**
+ service oriented mentality, high sense of ownership of the problems and requests assigned, with a focus to resolve issues in alignment with internal and sponsors’ SLAs;
+ initiate and perform changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes;
+ Good communication and interpersonal skills; establish and maintain communication with others to keep them updated with the status of their requests;
+ Documentation skills for processes and procedures (creating KBs, runbooks, topology etc.);
+ Good problem solving, analytical and organizational skills;
+ Strong collaboration skills; a team player;
+ Good numerical skills.
Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.