Sonika Agrawal Email & Phone Number

New York, NY, US

• Responsibility
• Migrate on-premise applications and databases to Azure Cloud
• Manage cloud resources, users, security, capacity & monitoring
• Implement and automate the deployment of IaaS and PaaS services in Azure
• Develop cloud infrastructure pipeline using Terraform, Jenkins to streamline provisioningprocess for Azure
• Design architecture for high availability

New York, NY, US

Database Admin ResponsibilityLead DBAs to manage, administer, monitor production Oracle and SQL Server databases.Design and implement RMAN for backup and recovery and OEM for the real time monitoring for NYC Transit databases.Analyze & troubleshoot performance issues and assist developers and application teams with performance tuning. Cloud Admin.

Dallas, TX, US

• Manage database service end to end from consulting, architecting, automation, monitoringto operation, supporting multi-TB email marketing applications
• Grew team from 2 members to 5 data administrators and 4 data engineers​. Improvingteam performance through coaching, mentoring, goal building
• Setup highly available data infrastructure​ for Infogroup' new business - email marketingfrom data ingestion using Talend ETL tool to running market campaigns using IBM Unica.
• Created and implemented holistic backup and restore strategy​. Being a new business,there were no backup were taken before.
• Onboarded high value clients - American Express and Atena. Storing 50 TB+ data, ingesting50 MB+ every night, running multiple email campaigns, sending out 1.5 million+ emailsdaily.
• Introduced multiple tier monitoring/reporting​ to address different user base from clientto site reliability engineer (SRE). Used combination of Oracle Enterprise Manager,SolarWind and monitoring scripts.

Nutley, NJ, US

• Managed database services for over 100 pharmaceutical applications. Oversee analytics ofover 20 TBs of data and 250 Oracle/SQL Server database instances.
• Managed 8 data administrators and engineers to provide end-to-end hosting servicesincluding design, monitoring, budgeting and operational services.
• Developed data migration, backup and restore strategies as part of managed services.Designed disaster recovery solutions.
• Delivered a high availability and disaster recovery implementation project for critical andhighly visible business applications (ARISg, Clinical Trial, SAP) using Oracle physical DataGuard. Led team to implement Golden.
• Led a cross-functional team to deliver a project to build an emergency evacuation applicationto assist employees who are stranded in the building during an emergency, which entailedcollaborating with SafetyNet vendor.
• Managed projects for enterprise architecture, including database administration, planning,design, implementation, monitoring, standards, and compliance.

CA

1. Analyzed business and technical requirement of commercial and government contract management of pharmaceuticals products. Worked with iMany to provide the solutions through it's products - Government Pricing, Medicaid, CARS2. Designed Database modeling using Erwin tool.3. Performed Day-to-Day DBA tasks - performance & tuning, database design, data.

New York, NY, US

1. Worked on Prospect CRM project - Responsible to administrate the Siebel CRM Data Warehouse, Data Mart and Informatica ETL tool repository.2. Designed, developed and deployed complex ETL mappings in Informatica.

Toronto, ON, CA

Worked as Business Analyst for the following products: -TakeOverStock that provides a unique blend of pertinent facts, industry research, legal analysis, and regulatory insight. www.takeoverstockreport.com- VentureXpert and RB Web are the sources for comprehensive analysis of investment activity and performance of the private equity industry..

New York, NY, US

1. Developed the enterprise wide data warehousing strategy. 2. Designed the database schema and architecture. 3. Minimized performance impacts to transactional systems by having management information in separated relational databases and/or On-Line Analytical Processing (OLAP) data cubes.

Master Of Computer Applications - Mca, Masters In Computer

Pmp Training

Bachelor Of Science (B.Sc.)

Certified Scrummaster