Data Administrator

Database Administrator Anitha Doddaiah

Page * of 2

Anitha Doddaiah Phone: +1-602-***-****

Mailto: ******.***@*****.***

www.linkedin.com/in/anitha-doddaiah-39914a90

Experience Summary

A Database Administrator specializing in IBM DB2 UDB with over 7 years of experience in design, implementation, testing, integration solutions and production support of various applications in the banking, financial services, and e-commerce domain. Highlights

• Provided production support for over 100 live databases (both OLTP and OLAP)

• IBM Certified Database Administrator DB2

• Performed installation of MongoDB - created databases and supported replication cluster

• Actively supported teams in creating high-availability databases using Q replication, HADR and active-active clusters

• Worked on AWS tools for database services

• Implemented DR and business continuity solutions

• Performed automation scripting for database administration and maintenance activities, managing over 50 database instances

• Categorized major database defects and documented their root causes resulting in significantly shorter resolution time

• Experienced in Performance Tuning of SQL and Stored procedures.

• Proficient at instance and capacity management

• Received 2 certificates of excellence for contributions to critical projects Technology Portfolio

Database: IBM® DB2 UDB v8, v9, v9.7, v10, v10.5, MongoDB, Couchbase, Postgres Language: Shell scripting

Operating System: Linux, UNIX (HP-UX, AIX and Solaris) Tools: Jira, BMC monitoring tool, Mongo Ops manager, Control M tool, ServiceNow, Capacity tool, DBArtisan, Squirrel, Autosys, data studio Work Experience

Cognizant – Development Support DBA Oct 2016 - Till Date Client: American Express

• Created databases and managed access permissions and privileges of MongoDB

• Monitored replication and completed performance tuning of MongoDB

• Performed periodic health check of DB2 databases Database Administrator Anitha Doddaiah

Page 2 of 2

• Supported application data movement on MongoDB and DB2 Aditya Birla Online Fashion (ABOF) – Database Administrator May 2016 – Sept 2016

• Maintained IBM WebSphere Commerce databases hosted on AWS

• Automated jobs on database servers and set alerts for application requirement

• Simulated production like databases on Docker containers to aid application development

• Collaborated with data analysts to develop queries and create BI reports

• Supported the development of database change request process that was used to deploy changes across multiple environments

• Performed database audits and fixed health check issues to maintain data integrity Genpact Headstrong Capital Markets – Application DBA June 2015 – May 2016 Client: Morgan Stanley

• Created database objects and populated tables for application deployment and testing in data warehouse applications

• Performed stored procedure reviews and SQL optimization of data reporting applications

• Scheduled application jobs, including archival and purge of old data

• Performed database maintenance activities using security and access control tools

• Standardized data structures to enable data hygiene Tata Consultancy Services – Database Administrator Mar 2010 – June 2015 Client: American Express

• Designed, configured and maintained databases across different environments

• Implemented a library of homegrown scripts to automate the scheduling and monitoring of periodic maintenance jobs including reorg, runstats, backup, load, export, db2look, etc

• Monitored and tuned database systems using various tools and reports for improved system performance

• Designed, tested and implemented backup, recovery policies (offline & online backups: Full, Incremental & Delta Incremental) and supported disaster recovery solutions using HADR, HACMP and replication

• Performed capacity planning and system resources allocation

• Designed database schema by adhering to data standards and managed controlled access

• Performed database integrity checks and resolve performance issues for queries dealing with logs, locks, utilities and CPU utilization

• Provided 24/7 support for production databases ensuring high data availability

• Maintained partitioned databases (DPF) of several terabytes spanning multiple nodes Education Summary

Bachelor of Engineering, specializing in Electronics and Communication Engineering from Visveswaraiah Technological University, Belgaum, Karnataka, India.

Contact this candidate