Job description

Job Description : • Key Responsibilities include, but are not limited to: - Maintain and support databases/instances required by application - Monitor incident ticket queue and resolve database incidents within SLAs - Monitor backup results and resolve/troubleshoot failed database backups - Provide daily development support to application teams including database connectivity, configuration (index creation, database layout, schema changes) and Data migration - Monitor database and server performance and identify current and potential bottlenecks - Provide performance monitoring during all phases of the Application’s development lifecycle - Responsible for troubleshooting Database issues including collecting information through traces and other logging facilities - Provide database and SQL Tuning expertise through recommendation to application developers, vendors and other core Application teams - Provide Database configuration for optimal performance including Database Partitioning Update runbook documentation - Review and support installations of database maintenance and security patches and upgrade to supported release levels Qualifications: -7-9 Years of hands-on experience with Teradata database administration experience handling big size databases, providing support to EDW applications and databases - Experience in the use of Partitioning and indexing and Data models - Solid and proven skills in managing database lifecycle – builds, patching, backup and recovery - Experience with Linux (Redhat or SUSE), Solaris and Unix AIX is desired - Demonstrated use of scripting, Stored Procedures, Triggers, Cursors, Logins and Views - Results oriented, willing to take responsibility and accept accountability for action - Strong communication and leadership skills with the demonstrated ability to lead and influence technical professionals across the enterprise - Comfortable with ambiguity as needs change on a regular basis with a high degree of initiative and sense of urgency - Excellent oral and written skills with the ability to interact with senior management, technical subject matter experts, and business customers are essential in this role - Ability to work on multiple initiatives and projects simultaneously - Ability to operate in a support role, assuming on call responsibilities - Ability to work with offshore teams

Requirements

Must-haves

Key Responsibilities include, but are not limited to:
Maintain and support databases/instances required by application
Monitor incident ticket queue and resolve database incidents within SLAs
Monitor backup results and resolve/troubleshoot failed database backups
Provide daily development support to application teams including database connectivity, configuration (index creation, database layout, schema changes) and Data migration
Monitor database and server performance and identify current and potential bottlenecks
Provide performance monitoring during all phases of the Application’s development lifecycle
Responsible for troubleshooting Database issues including collecting information through traces and other logging facilities
Provide database and SQL Tuning expertise through recommendation to application developers, vendors and other core Application teams
Provide Database configuration for optimal performance including Database Partitioning
Update runbook documentation
Review and support installations of database maintenance and security patches and upgrade to supported release levels
-7-9 Years of hands-on experience with Teradata database administration experience handling big size databases, providing support to EDW applications and databases
Experience in the use of Partitioning and indexing and Data models
Solid and proven skills in managing database lifecycle – builds, patching, backup and recovery
Experience with Linux (Redhat or SUSE), Solaris and Unix AIX is desired
Demonstrated use of scripting, Stored Procedures, Triggers, Cursors, Logins and Views
Results oriented, willing to take responsibility and accept accountability for action
Strong communication and leadership skills with the demonstrated ability to lead and influence technical professionals across the enterprise
Comfortable with ambiguity as needs change on a regular basis with a high degree of initiative and sense of urgency
Excellent oral and written skills with the ability to interact with senior management, technical subject matter experts, and business customers are essential in this role
Ability to work on multiple initiatives and projects simultaneously
Ability to operate in a support role, assuming on call responsibilities
Ability to work with offshore teams

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium