Anitha Udayan
- Database Administrator
- New York City, NY
- Member Since Apr 23, 2023
Candidates About
Anitha Udayan
Experience Summary
- 18 years of extensive experience as an Oracle Database Administrator specialist in managing OLTP and DSS Oracle databases of multi-terabytes. Experienced in providing 24x7 production support for mission critical systems. Monitoring and supporting production and non-production databases. Expertise in implementing advanced features of Oracle 11g R2 RAC grid infrastructure, Oracle 10g/11g R1/12c, OEM, Data Guard, ASM, RMAN, Oracle Upgrades, patches, migration, backup and recovery, performance tuning, cloning, disk space management and advanced security options.
- Proven Experience in installation, configuration and administration of core edge technologies of Oracle 11g R2 RAC grid infrastructure, 10g RAC, standby databases, and other oracle versions 12c, 10g, 9i & 8i on SUN SOLARIS, LINUX, for OLTP and Data Warehousing.
· Proficient in Oracle RAC installations, Data guard implementation for real time Replication using DGMGRL, creating and maintaining Physical Standby Databases, Snapshot Standby Databases and Logical Standby Databases.
- Performance Tuning, Data Migrations, Capacity planning for database storage, Oracle version upgrade, Patching, Data modeling,
- Implemented Advanced data security measures using Oracle Wallet manager, Data Encryptions (TDE) to Address databases security across all supported environments to ensure data is secure and encrypted over the network (from the application server to/from the database server) as well as encrypting sensitive/PII data at rest within databases, data masking, Real Application Testing.
· Experienced in implementing Backup and recovery strategies, cloning databases, Hot Backups and Logical Backups, ASM Data storage management, Oracle Enterprise Manager.
· Automated scripts for database backup and recovery and monitoring databases, performance issues etc.
- Proficiency in efficient usage of the disk space management and good understanding of Capacity planning.
- Excellent analytical and troubleshooting skills for resolving production database issues.
· Tuning the databases for achieving optimal performance on the production databases. Proficient in using Explain Plan, TKPROF, STATSPACK/AWR Reports, SQL TRACE, ADDM, OEM, SQL tuning Advisor, custom scripts and Wait Event Analysis etc.
- Experienced in implementing Data Archival and data purging,
- Implemented best practices for database coding practices, ensuring database security plan and auditing.
- Troubleshooting database issues by creating Service Requests with Oracle Support.
- Experienced in code reviews, supporting production releases, review Database Runbooks that document database policies and procedures.
- Experienced in Data Center Migrations with reduce downtime plan.
- Experience with the Remedy Change, Incident, Problem, Asset management tool.
- Experience in various databases MSSQL, MySQL
· Good team player, excellent ability to work both independently and in team. Experienced in managing and mentoring DBA team.
· Configured Golden Gate.
TECHNICAL SKILLS:
Database Versions : Oracle 12c, Oracle 11g R2, Oracle 11g R1, Oracle 10g, Oracle 9i, Oracle 8i
Sql Server 2000/2005, MySQL
Database Languages : SQL, PL/SQL
Database Technologies : RAC, Oracle 11g R2 Grid Infrastructure, Dataguard, Cloning, Upgrade and Patching
Database Tools/Utility : ASM, ACFS, RMAN, DG Broker, SQL Loader, Data Pump, OS Watcher, RDA, OEM, Ms Visio, ERWIN
Storage Technologies : NFS, NAS, SAN, Net App, EMC
Operating Systems : RHEL 4/5, OEL 4/5, Windows 2000, Solaris
Certifications:
- Oracle Certified Professional for Oracle 10g Database Administrator (OCP)
- Oracle Certified Professional for Oracle 11g Database Administrator (OCP)
- Oracle Certified Expert for Oracle RAC 11g and Grid Infrastructure Administrator
- ITIL Foundation Certification
Trainings:
- Exadata Database Machine: 12c Administration Workshop by Oracle University
- Oracle Grid Infrastructure 11g Manage Clusterware and ASM by Oracle University
- Oracle 10g database administration by Oracle certified partner
- Oracle 8i architecture, SQL query writing, Developer 2000 by Oracle certified partner
EDUCATION
- Master in Computer Application (MCA) ,Regional Engineering College, Sambalpur University, Orissa - India
- Bachelor of Science B.Sc ( Maths, Physics, statistics) ,Kerala University - India
PROFESSIONAL EXPERIENCE
Title: Database Administrator at Metropolitan Transport Authority (US) Mar 2013 –till today
§ Administration and monitoring of high available Oracle RAC 11g R2/R1 Production Databases, disaster recovery databases, Test databases and Development environments on RHEL V5.5
§ Installation of Oracle 11g R1, of Oracle 11g R2 RAC database, Oracle 12c Multitenant databases
§ Mission critical Production support on rotational basis to provide 24X7 support
§ Implemented high availability databases for RAC and non-RAC databases, created active standby databases, snapshot standby database using dataguard, DGMGRL and RMAN
§ Oracle Upgrade from 11gR1 to 11g R2, applied patches
§ Core member in mission critical Datacenter migration project, Disaster recovery drills and other major projects like Peoplesoft upgrade etc.
§ Implementing code changes on production, Development support, code reviews
§ Cloning database for development, testing and pre-production
§ Implemented security policies using data masking, data encryption TDE and Oracle Wallet.
§ Automated scripts for backup and recovery , database health monitoring, Replication monitoring
§ Database performance tuning using AWR, ADDM, OEM, Performance Views and other utilities
§ Capturing and replaying production loads on test database using Real Application Test (RAT).
§ Troubleshooting databases issues and working with Oracle support
§ Service Now : Work with the Remedy Change, Incident, Problem, Asset management tool
§ Best practices for coding standards.
Title: Senior Associate Database at Sapient Corporation Apr 2006 – Nov 2012
Scotia Bank, Canada Data warehouse project Senior Database Administrator
§ Installed of high available Oracle RAC 11g R2 database for Test/UAT, Development environments on RHEL V5.5
§ Key member Procured Infrastructure, involved throughout the lifecycle of the project
§ Release deployment guide, technical documentation, Development support, performance testing, code reviews
§ Production Site Capacity Estimation, Physical Modeling,
§ Backup and Recovery strategies,
§ Implemented Best practices for coding standards ensuring to meet banking security policies
§ Performance tuning of database and SQL queries and reports to meet SLA
§ Lead infrastructure and DBA team
§ Oracle 11g R1, Oracle 11gR2 RAC and Grid Infrastructure, Toad, Sql Developer, AWR, Statspack, ADDM, RMAN, Datapump, OEM, SQL tuning Advisor
O2, UK Telecom Client Senior Production Database Administrator
§ Installed High Availability Oracle RAC 10g R2 database for Pre-Production, Testing, UAT, Development environments on RHEL V5.5 , 24x7 Production support for the mission critical databases of multi-terabyte
§ Configured disaster recovery databases Implementing Data Guard, configured physical and logical standby databases for real time data replication for production and non-production environments
§ Oracle version upgrade, Oracle Patch apply on multiple databases
§ Implemented data security using Transparent Data Encryption (TDE) and Oracle Wallet Manager, Data masking
§ DB capacity planning, Designing Databases with effective storage parameters to increase performance
§ SME for database and replication issues
§ Production Go-lives with reduced downtime,
§ Backup/recovery strategies and Implemeted Data Archival and Purging policy. Security Audit
§ Optimization of database, business critical reports and application codes to meet SLA
§ Monitoring DB health, Identify and resolve any database bottlenecks proactively
§ Troubleshooting and resolving P1 issues on production
§ Lead and mentored DBAs
§ Support to MySQL forum databases for Production and non-production
Other Few Noteworthy Projects:
TSL Education Ltd, UK (Education site Client) Senior Database Consultant
- Data Modeling, database design, Capacity Estimation Plan for Production and UAT servers (~1TB each)
- Migrated data from SQL 2005 to SQL 2008, Code reviews
United Utilities, UK (Water Billing Client ) Technical Designer
- Re-designed to optimize various modules for generating monthly water utilization bills
- Resolved discrepancies in the meter readings, water billing and debt management modules.
- Enhancement of existing modules for better performance
- Oracle 9i , SQL tuning, PL/SQL , SQLloader
Franklin Templeton, US (Investment banking Client) Senior Production Database Administrator
- Performance tuning of database, sql Reports and stored procedures , Tables Partitioning , Materialized views
- Core member of performance tuning team, Attended Status calls , client calls, technical discussions
- Oracle 10g, SQL, PL/SQL
NHS, UK (Healthcare Client) Senior Database Administrator
- Requirement gathering, data modeling for reference data for datawarehousing project
Vodafone, UK (Telecom Client) Senior Database Administrator
- Installed development, test databases, Production support
- Development support, code reviews, deployment guide manual
- Performance tuning of bottlenecked sql queries
- Oracle 10g, AWR, Statspack
Hilton Hotels, UK Senior Database Administrator
- Installed development, test databases
- Involved in throughout lifecycle of the project, Development support, code review, deployment guide manual
- Performance tuning of database, sql queries, stored procedures, packages
- Implemented best practices of Coding standards.
- DB health monitoring, backup and recovery policy, Data archival policy.
- Oracle 9i, SQL, statspack, tkprof, explain plan
Hotels.com, UK Travel Client (UK) Database Administrator
- Installed development, test databases
- Data modeling , technical design, Development support, code review, deployment guide manual
- Coding standards, best practices, Implemented DBCR lifecycle, performance tuning
- SQL server 2000
Expedia.com, UK Travel Client (UK) Database Administrator
- Installed development, test and pre-production databases
- Data modeling , technical design, Development support, code review, deployment guide manual
- Implemented best practices for Coding standards, Implemented DBCR lifecycle, performance tuning
- SQL server 2000
Title: Senior Oracle DBA at STI Software Solutions (India) Sep 2005 – March 2006
§ Database administrator, technical designer, Performance consultant
§ Installation of oracle database servers development, test, UAT environments
§ Refresh environments from production data
§ Monitoring DB health, performance tuning of database, sql queries, stored procedures and packages
§ Statspack, TKPROF, DBMS_profiler
§ Oracle 8i, SQL, PL/SQL, Sun Solaris 5.8
Title: Assistant Director/ System Analyst at Apparel Export Promotion Council (India) June 1998 – Feb 2005
§ Senior Consultant /Systems Analyst/ Infrastructure Analyst/Team Lead, database administrator
§ Designed and led 10 member team to develop exporters’ registration system, online transfer of export quota across the country, shipping bill endorsement, membership, discrepancies, and other in-house developments
§ Liaison with vendors for econo-commercial procurement of Hardware, software , networking equipment, security solutions, AMC
§ Developed payroll system, Time management system, Income tax system, India International Garment Fair registrations system
§ Core organizer in arranging India International garment fair
§ Oracle 8i, SQL, PL/SQL, Designer 2000, Pro*C, HP-UX
Title: Programmer at National Water Development Authority (India) Feb 1991 – June 1998
§ Designed, Developed for estimation of basin-wise hydro-electric power potential in the east flowing peninsular rivers basins, evaporation losses from reservoirs using simulation technology.
§ Developed GIS for river system India
§ Registrations for International Water Resources conventions
§ Initiated computerization, Rolled out organization-wide trainings.
§ FORTRAN, BASIC, dbase III Plus, GIS
EXPERIENCE BEYOND PROJECTS
- Technical and Business Trainer, Facilitator , Facilitated best Database coding practices for developers
- Team Mentor
OTHER RELEVANT INFORMATION
- Authorized to work in US
- Preferred mode of contact : email