What does a great Senior Technical Operations Analyst - Development DBA do? As a Technical Operations Analyst Sr Development DBA, you will be responsible for the Card Services databases supported by the AppOps organization.
Development DBAs work with the infrastructure DBAs following all documented guidelines for release management, change management, patching support, compliance, and disaster recovery.
The primary function is to work with the development and Tier II support teams for SQL tuning, INDEX review and management, capacity planning, stored procedure testing.
Development DBAs will work with assigned AppOps Tier II teams on release testing, preparation, and execution. Development DBAs will provide support for during incidents and will be part of the post-incident problem review team to assist with preparing and publishing the Incident RCA.
There will be on-going focus on improving monitoring of the database environments using existing monitoring tools and when required to prepare a case for the implementation of new or improved monitoring tools for the database environment.
Responsibilities include : + Hands-on Change Management tasks - review and support all changes which required any modifications to a supported database.
Represent Database changes on Start of Day Operations Call+ Attend DEMO Meetings with development+ Attend monthly change audit meeting with internal auditors+ Review SQL code and Indexes for performance improvement+ Review and updating monitoring and make recommendations for improvement+ Automate database deployment tasks+ Support all infrastructure tasks for patching and compliance+ Prepare and participate in disaster recovery tasks and tests+ Monitor production databases for any performance degradation and remediate+ Provide technical updates to AppOps on any database upgrades and DOT releases Basic Qualifications for Consideration : Preferred Skills, Experience, and Education : + Bachelor's degree preferred+ 3+ years of experience as an ORACLE Development DBA+ SQL server knowledge a PLUS+ NOSQL Database experience a PLUS (, Coherence, Mongo)+ Expert level experience with Microsoft WORD, EXCEL and PowerPoint+ Experience with PowerBi, SQL writing and execution a plus+ ITIL experience a plus+ Experience in Agile and DevOps environments and cultures+ Understanding of full life-cycle development experience in a technology driven environment+ Experience with financial services and / or banking preferred+ Working knowledge of Windows, Unix / Linux, Application Servers, Database Servers, basic networking+ Experience with monitoring tools (Splunk, ExtraHop, AppDynamics) Travel Required : + No travel required