Engineer Management

Nanditha Krishnamurthy Haradana Halli

Oracle and Microsoft SQL Database Consultant

Sunnyvale, California, USA

Ph: +1-650-***-****, Email: n ac3r8i@r.postjobfree.com, Linkedin: h ttps://www.linkedin.com/in/nanditha-hk-09315047/ Experienced database management and administration consultant looking for a challenging technical role in the Bay Area, California.

Experience [10+ years]

Senior Engineer (November 2013 - May 2017), HCL Insys, Singapore. Worked as Oracle and MSSQL database consultant for several Singapore government agencies such as Singapore Central Provident Fund, Singapore Building Construction Authority, and Singapore Media Development Authority.

Supported a 5TB data warehouse. Resolved performance-tuning issues and RMAN backup issues. Worked actively on 11g technologies such as Golden Gate, DR Dataguard, RAC, ASM, MSSQL AlwaysOn. Monitored databases by collecting performance statistics regularly. Reorganized indexes on major tables. Provided on-call support for enterprise edition databases. Technical Lead (October 2012 - October 2013), Wipro Technologies, Birmingham, UK. Worked as an Oracle database lead for a small team of 4 people in a National Grid project, UK. Cloned a network of four Oracle databases that record important events in the city gas supply grid for testing and troubleshooting. Reconfigured the clone with production configs using AQueue and Streams. Actively provided feedback to the application team for fixes. Tuned performance using EXPLAIN PLAN and STATSPACK/AWR. Performed incremental and full backups using RMAN, and traditional hot/cold backups. Installed and maintained Oracle 10g RAC/Oracle 11g RAC and standby databases for High Availability and Disaster Recovery purpose.

Senior Engineer B2 (October 2010 - October 2012), Wipro Technologies, Reading, UK. Lead a team of 6 working on Oracle and Microsoft SQL database technologies in the Thames Water project, UK.

Performed a lead role in enterprise-wide database optimization, and instance and resource monitoring. Set up new databases and provided all database-related support for production as well as test databases for different international markets. Performed space estimation and calculation, application installation, performance/memory tuning, server/database monitoring, configuration, and troubleshooting. Provided design input and interacted with the design team on best database practices. Evaluated server/instance architecture, hardware, system specifications, and capacity planning. Formulated recommendations about optimal storage configurations for senior management. Managed schemas, objects and partitioning of tables and indexes. Upgraded Oracle databases from 9i to 10g & 11g, and from 10g to 11g. Senior Engineer B1 (October 2008 - October 2010), Wipro Technologies, Bangalore, India. Worked as a database administrator in Oracle and MSSQL database technologies in Paramount Pictures, USA and Thames Water project, UK.

Used ‘Explain Plan’ along with Oracle-optimizer hints to enhance performance of PL/SQL statements. Troubleshot all kinds of clustering and replication tasks. Performed daily backups on both disk and tape. Exported and imported data. Ensured system-level security using security hardening in addition to creation of users at instance and database level. Installed and maintained different versions of MSSQL Servers (2014, 2012). Upgraded server databases from MSSQL Server 2000/2005 to MSSQL Server 2008/2012.

Engineer (October 2006 - October 2008), Wipro Technologies, Bangalore, India Worked as a database administrator in MSSQL database technology in Cardinal Health project, USA, and Paramount Pictures project, USA.

Configured clustering and replication tasks such as Active-Passive Clustering, Database Mirroring, Transactional Replication, MSSQL Server Profiler, Log Shipping and Client/Server Connectivity. Resolved deadlocks, handled isolation levels and performance issues like CPU, I/O and memory bottlenecks. Performed database consistency checks using DBCC Utilities. Planned and implemented database security by creating logins, users, roles, and permissions. Configured MSSQL Server Integration Services (SSIS) packages and SSRS reports. Installed and maintained different versions of MSSQL Servers (2008, 2005, 2000) in both OLTP and OLAP. Upgraded MSSQL Server databases from MSSQL Server 2000/2005 to MSSQL Server 2008R2.

Skills

Oracle database technology: maintenance (9i, 10g, 11g) and upgradation (9i/10g to 10g/11g on Sun Solaris and IBM AIX), performance tuning, capacity monitoring, backup and recovery management (RMAN, EXPDP/IMPDP), disaster recovery, clustering (RAC), storage management (ASM), replication management (Golden Gate, Dataguard), patching, security hardening.

MSSQL database technology: upgradation (2005/2008 to 2012), performance tuning, capacity monitoring, backup and recovery management (export/import), disaster recovery, clustering, replication management (AlwaysOn, Transactional Replication, Mirroring, Log shipping), patching, security hardening. Microsoft certified technology specialist in MSSQL 2005 server technology.

Others: O racle to MSSQL migration, datacenter migration. Education

Bachelor of Engineering in Electronics and Communication, 2002-2006 Yellamma Dasappa Institute of Technology, Bangalore, India.

(Affiliated to Visvesvaraya Technological University, Belgaum, India) Other interests

Painting, Drawing, Rangoli, Exercise

Contact this candidate