JOB RESPONSIBILITIES: Performs database tasks (installation, setup/configuration, patch installation, user/object creation, testing / capacity monitoring ) for existing systems. Defines, performs and assures database backups and recovery procedures are in place. Coordinates regularly with members of other support teams for database related issues and concerns Provides 24/7 database support (handling incidents, migration, db tuning and maintenance, including on-call , onsite support when needed. Addresses database non-compliance and escalates issues as needed to the application/system owner (vendor, developers, etc) and Cluster head Performs database analysis and optimization (SQL tuning, adjusting database parameters, schema design) Communicates needed changes to the Cluster Head and application owners. Proactively monitors database for optimum performance. Works closely with Systems Administrators to monitor both software and hardware so that it functions optimally with
the RDBMS Performs database migration and upgrade of production servers; provides onsite support during these activities Complies with all operational standards and other requirements Reviews and prepares system documentation (database profiles, PPMs) Participates actively through discussion during a turnover of systems from projects to production Proactively monitors production databases (including capacity issues) and addresses/ escalates potential problems/ issues Executes production related service requests within agreed SLA Addresses and resolves assigned incident in a timely fashion Determines root cause and documents resolutions Provides end-to-end communication and closure of incident statuses to immediate supervisor and all concerned
parties Provides inputs to Cluster head on standards and processes to assure that all production systems runs optimally
24/7 with no or limited incidents. Provides weekly feedback of all production activities and incidents statuses to the Cluster head REQUIREMENTS: Bachelor's degree in related technical discipline 5+ years' experience as a Database Administrator DISPLAYS:
Strong grasp of fundamental relational database concepts Knowledge on setup, configuration and management of different databases (Oracle, Sybase, MS SQL) Knowledge on setup and maintenance of clustered / replicated databases (Oracle, Sybase, MS SQL) Knowledge of advanced UNIX administration commands DELIVERS:
• Database support for assigned production systems
• Database systems that fully comply and adhere to implementation standards of the department unit
• An optimally configured database
TECHNICAL SKILLS:
• Experienced in SQL/PL-SQL/T-SQL programming
• Thorough understanding of relational database design, normalization, indexing #J-18808-Ljbffr
