DBA Operations

Job Description

• Periodic on-call support responding to incidents and incident bridges
• Change Management implementation. Changes are frequently implemented outside business hours and overnight.
• Provide first-level database support: Resolve problems and answer questions related to the database and platform environment (Linux, AIX, VMware), contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiency
• Maintain database backup/recovery environment: Assure that data recovery time objectives are established and met; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error; respond quickly to refresh data.
• Database performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency
• Install and upgrade database and related products: Keep database at current release and maintenance levels; install supporting products; provide current, stable production and development environments
• Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or defragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance
• Perform application refreshes on request: Refresh data from one environment to another at the request of the application development staff; execute necessary tasks to accomplish this, including export, drop, create, and import pre-scheduled time to minimize impact; provide application development staff optimal development environment with current data
• Capacity planning and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim unused space; optimize space allocation and avoid out-of-space conditions
• Work closely with Systems Programmers and Systems Administrators to ensure that the database system is operating in accordance with required system usage; provide assistance and guidance in setting appropriate system parameters
• Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
• Communicate complex technical information in a concise and articulate manner
• Participate in the evaluation and recommendation of DBA tools and new DBMS technologies

Skills and Knowledge:

• Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques; skilled in ability to see the big picture and conceptualize and document creative solutions
• Ability to design and implement backup and recovery of databases under various failover and switchover events.
• Excellent oral and written communications skills
• Strong interpersonal skills at all levels of management and ability to motivate employees/teams to apply skills and techniques to solve dynamic problems; excellent teamwork skills
• Ability to weigh various suggested technical solutions against the original business needs and choose the most cost-effective solution
• Knowledge of SQL, including programming and ways to optimize SQL code.
• Ability to quickly learn, adapt to, implement and migrate current database technologies to new open source environments, specifically Postgres, MySQL and Mongo

Required Experience:

• Bachelor s degree or better in Computer Science, Engineering or related discipline
• 3+ years in-depth experience in administration and support of Oracle Enterprise RDBMS
• 1+ years extensive experience in at least 2 of the following technologies: ASM, RAC, GoldenGate, DataGuard
• 3+ years operating knowledge of various UNIX environments, specifically RedHat and CentOS
• 2+ years UNIX shell scripting experience
• Demonstrated experience working well with customers of varying levels of technical expertise in high-pressure situations and complex environments

Preferred Skills:

• Experience in Agile management methodologies
• Experience with ServiceNow
• Experience with Jira and Confluence

,

Keyskills :
unixshellscriptingdataguardopensourcedatarecoveryshellscriptingcomputerscienceoldengatefilesystemfederallawdataintegrityoncallsuppagemanagementproblemresolutionmaterializedviewsspectrummanagement