Parag D. Email & Phone Number

San Diego, Ca, Us

* Mentored and coached new technical talent with defined outcomes and timelines that would align with corporate goals.* Collaborated with various technical teams and management for the development, maintenance, testing, implementation, and support of database technologies and associated software products.* Provided financial analysis, planning, and forecasting to reduce total cost of ownership and allocate resources efficiently for the backend systems. * Led and managed a global team of Database Engineers responsible for maintenance & administration for all database management systems including SQL server (2008 to 2019), PostgreSQL, Cassandra in various international datacenters.* Partnered with vendor managed services and planned 24X7 monitoring and support around all DB systems.* Collaborated with multiple IT team and business units for onboarding Database systems into corporate Servers as a part of M&A activities.* Responsible for Microsoft True up regarding SCE and EA agreements and licensing of SQL servers located at all the data centers including international sites.* Actively engage vendors for resource planning and augmentation as and when to successfully reach corporate goals.

San Diego, Ca, Us

* Architect a hybrid environment on multi-Cloud platforms across various Zones and international Regions.* Designed High availability solutions (FCI, AG with geo clustering) and DR strategies to meet RTO and RPOs for critical ERP systems and Enterprise Data Warehousing systems.* Built and designed Architecture for SQL server 2012/2014/2016/2017/2019 AlwaysON Failover Cluster Instances and AlwaysON AvaialblityGroup along with Multi-subnet Clusters in geographically dispersed data centers.* Automated Non-Production Refresh strategies with quick turnaround and minimum Downtime for multi-TB database systems spanning different Data centers. * Planned automation of all SQL Server monthly patching including multi-node Clusters and AG nodes with for all production and non-production environments. * Guided DBA team members to partner with various teams (Tech, Ops & Compliance) to document data issues, perform Root cause analysis and determine remediation plans when required.* Designed and built database backup and recovery strategies both on premise and cloud backups for long term retention.

San Diego, Ca, Us

* Setup Multiple SSRS instances for scale out deployment and SSIS packages for ETL purposes, Between various Datacenters replicating Master Data across various ERP systems and database systems in cloud* Collecting performance Data for Critical production systems to baseline and use as a reference in future performance tuning if necessary.* Designed automated evidence collection for various Compliance requirements including SOX, PHI related data. * Provided 24 X 7 dedicated support and escalation for all Production and critical database systems .* Procurement and implementation of various monitoring and alerting solutions for Production Databases and defining thresholds and Dashboards for the same.

Irvine, Ca, Us

* Responsible for Installation of SQL server 2005 / 2008 and installation of latest Service Packs and hot fixes in all Environments. * Migrated databases from SQL Server 2000 to SQL Server 2005 and from 2005 to 2008 in test, BETA and production environment. * Setup database maintenance plans for weekly maintenance and setup jobs for backups to disks and especially tape libraries for TSM servers using IBM TDP utilities. * Configured new SQL server instances, Created Database alert scripts like database size increase, log size full and maintenance scripts for all SQL Server versions. * Responsible for database backup & restore, monitoring production servers’ activity, problem solving, scheduled jobs, SQL Server Error Log, space usage and other on call tasks. * Created various database objects like views, triggers, stored procedures, clustered/non-clustered indexes on the tables. * Extensively used SSIS, BCP, BULK INSERT to import & export data from flat files, excel and MS Access to MS SQL Server databases and Oracle. * Assisted the SQL developers to optimize the SQL queries and stored procedures. * Configured IIS and created URLs for SSRS 2005 with IP allocation. * Implemented DR, setting up Log Shipping using RedGate SQL Tool Belt. * Responsible for all Production SQL servers, server maintenance, implementation of change control in QA & Production and sync the DR servers with production. * Participated in DR drills for SOX compliance to ensure High availability of the production servers.

Jersey City, Nj, Us

* Installed and configured of SQL Server 2005/2000 on windows server 2003 OS. * Designed the migration architecture and the execution plan for the migration. * Designed the backup strategy on the new servers. * Created and designed several database maintenance plans for various database consistency checks. * Involved in configuration of new SQL Server Instances on Windows servers with appropriate parameters. * Participated in migration of the databases and managed the location of database files and their sizes. * Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2005/2000 and databases. * Developed scripts for maintaining administration tasks. * Configured the MAPI for the SQL Mail and created different operators to send out alerts and notifications from the scheduled jobs. * Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.