Consultant, Database Engineer- IHM
Discover Financial Services
2 weeks ago
DFS Corporate Services LLC seeks Consultant, Database Engineer in Riverwoods, IL to Participate in on-call pager rotation support for database installations and upgrades. Build Data Guard across data centers for large databases. Participate in troubleshooting, resolving standby synch issues and supporting replication, switchover and failovers. Participate in configuration and database monitoring including alerts on Oracle database patching and database vulnerability management. Participate in database weekend Change implementations including implementation calls with application teams. Perform database migrations using Oracle Golden Gate SQL Tuning, using indexes, baselines, statistics, EXPLAIN plans and access path evaluations. Participate in database performance tuning including ASH / AWRs analyses, SQL execution plans, baselines and profiles, tuning SQLs and memory components of the database. Utilize Change Management procedures. Provide L3 DBA support to offshore and first level support DBAs. Participate in database security compliance requirements. Implement database technology solutions for projects medium to large in scope. Provide support for Oracle Database backups and recovery, database software patching, database builds and installation and Data Guard Broker. Work with vendor Oracle on database problem resolutions. Support a number of applications including development, testing and production installation. Support security vulnerability management. Provide SQL expertise in query performance tuning and enhancements. Provide database consulting services to infrastructure, application and first level support teams. Promote a risk-aware culture, ensure efficient and effective risk and compliance management practices by adhering to required standards and processes.