Management Manager
Resume:
*************@*****.***
SONIKA AGRAWAL
SUMMARY
Manager of Database Services with over 15 years of database and team management experience. Build,
manage and support large scale global data platforms in virtual and physical environments, with a focus on
Oracle, SQL server and Hadoop ecosystems.
EXPERTISE
• Technical team leadership; onshore and offshore resource management
• IT project planning and management, innovation, production support, license management,
security and compliance, SLA management, process optimization and automation, risk
identification and mitigation, cross departmental collaboration
• Oracle, SQL server, Hadoop, Amazon Web Services (AWS), Double Take, replication, high
availability, business continuity/disaster recovery, OEM monitoring, RMAN Backup and Recovery,
RAC, Data Guard, Golden Gate
PROFESSIONAL EXPERIENCE
Manager, Database Services Feb. 2007 – Current
Eisai Inc., NJ
• Planned and designed database services and infrastructure solutions for over 100 pharmaceutical
applications. Oversee analytics of over 20 TBs of data and 250 Oracle/SQL database instances.
Led team to implement Golden Gate real time replication solutions for ARISg applications.
Delivered operational Hadoop cluster for CDR application.
• Manage daily Oracle/SQL Server database operations, production support and projects for
enterprise architecture, including database administration, planning, design, implementation,
monitoring, standards, and compliance. Developed JSOX compliance standard operating
procedures (SOPs) and application decommission process SOP by liaising with relevant
stakeholders from different departments to improve communication processes between business
and technical teams.
• Supervise 1 onshore and 7 offshore (5 Oracle/2 SQL) resources to implement clients’ applications
using end to end hosting services including design, monitoring, budgeting and operational
services. Led a cross functional team to deliver a project to build an emergency evacuation
application to assist employees who are stranded in the building during an emergency, which
entailed collaborating with SafetyNet vendor and five internal groups: network, compliance, web,
data center and business.
*************@*****.***
SONIKA AGRAWAL
Develop data migration, backup and restore strategies as part of managed services. Design disaster
•
recovery solutions. Delivered a high availability and disaster recovery implementation project for
critical and highly visible business applications (ARISg, Clinical Trial, SAP) using Oracle11g
physical Data Guard. Led team to develop SQL mirroring high availability disaster recovery
solutions for Lotus Notes e mail application across data centers in order to minimize downtime.
• Oversee license management for all database products. Directed team to segregate SAN for Oracle
database farms, reducing over $1.5 million Oracle license risks.
• Direct critical initiatives, customer meetings and management of deliverables as per SLAs.
• Report team’s database metrics, issues, and resolutions to management.
• Maintained 24/7 availability for mission critical application database support.
DBA Team Lead June 2005 – Dec. 2005
Biovail Pharmaceuticals Inc., NJ
• Set database procedures, standards, and documentation. Provided solutions and recommendations
for configuration and database best practices.
• Designed and implemented the transition from the Oracle and SQL Servers from non licensed
virtual farms into a well managed Oracle/SQL licensed farm in order to avoid compliance issues.
Senior Oracle DBA April 2004 – May 2005
The New York Times, NY
• Managed the production data warehouse CRM system. Supported operations and production.
• Designed and implemented a centralized monitoring solution to minimize business outages.
Senior Oracle DBA Mar. 2003 – Mar. 2004
Advisen Inc., NY
• Gained extensive hands on experience managing database production, development and testing.
• Decommissioned unused database servers to reduce maintenance, operation, and licensing costs.
Oracle DBA Nov. 2000 – Dec. 2002
Thomson Financial Inc., NJ
• Supported database management for various applications. Ensured database protection and backup.
Data Warehousing Administrator Feb. 1998 – Oct. 2000
24/7Media Inc., NJ
• Analyzed database reports to enhance automated performance and availability.
*************@*****.***
SONIKA AGRAWAL
EDUCATIONAL BACKGROUND
• Master of Computer Application, Institute of Management Studies, India.
• Bachelor of Science, Gharwal University, India.
• PMP Certification Prep Course, Technical Institute of America.
TECHNICAL SKILLS
RDBMS Oracle 12c, 11g, 10g, 9i, RAC, OEM, Golden Gate, SQL Server
Big Data Hadoop, HDFS, Map Reduce, Hive, Sqoop
OS Red Hat Linux, Ubuntu, Sun Solaris, Windows, VMWare
Others Double Take, TOAD, Grid App, Cloud computing, Amazon Web Services (AWS)
Applications ClinTrials, PKS, eCTD, SAP, ARISg, EDW, ProWatch, Nextiva, GP/CARS, Medicaid
Infrastructure Replication, High availability, Business Continuity/Disaster Recovery, Migration and
Upgrade
EMPLOYMENT STATUS: U.S. Citizen.
Contact this candidate