Sunil Seth Email and Phone Number

Support our mission to empower every person and every organization on the planet to achieve more.

Support company's mission to empower every person and every organization on the planet to achieve more.

Actively maintain 60+ SQL server instances in addition to installing and configuring Always On availability groups in SQL 2016 for PROD and DR environments. Create and maintain SQL server on EC2 and RDS instances. Setup Cloudwatch alerts for SQL server instances. Successfully manage teams and projects while running scrums, quickly identifying and resolving issues to avoid roadblocks.Design and develop databases using ER diagrams, normalization and relations database concepts.Create custom packages for data import/export, scrubbing and job scheduling for daily maintenance.Develop views and stored procedures, optimizing as required by R&D, QA and support departments.Perform database tuning using DMV’s, analyzing cache plans, blocking, deadlocking. Reduce query execution time by adding, modifying indexes.Implement business logic and procedures in backend using complex stored procedures.Plan, implement and maintain database security and permissions.Automate Dev environment refresh using power shell scripts.Support and maintain VLDBs with 10+ terra bytes in the production environment.Create and compare database baselines and monitor performance.Recognized as an SME in data extraction, transformation and loading (ETL) using various tools such as data transformation services, SSIS, and bulk insert.Translate design requirements into structured application programs and objectives using appropriate development methodologies through the application of global standards.Designed EC2 instance architecture to meet high availability application architecture configuration and security parameters, and introduced automation and continuous integration processes, saving $2.5MM in one year.Create S3 buckets and manage policies for databases and backup buckets.Provided services on AWS infrastructure with various resources, including VPC, EC2, IAM, security group, auto scaling and RDS ensuring the highest quality in all processes.

Successfully implemented, configured and troubleshot database instances, replication, backup partitions, storage and access while serving as the highest level of technical escalation for SaaS system issues.Implemented active / active and active / passive clustersPerformed integration between the SQL server and Fox Pro-based processes and automated the deployment process.Consistently collaborated with support and infrastructure teams, vendors and customers to quickly restore service interruptions. Managed a production environment consisting of 2.5K+ databases and 100+ production servers.Mentored a DBA team and other groups within IT, offering guidance and sharing technical knowledge.Planned and implemented Disaster recovery and security management.Managed high-availability and DR solutions, and counseled application developers in SQL coding, tuning, and the deployment of stored procedures.Implemented and released database changes submitted by development team.Provided database capacity management, including growth tracking and overall system usage.Participated in change management to approve and stay on top of upcoming database changes.Directed project teams and defined project scope in addition to running scrums and resolving issues. Utilized parallelism, lock management, memory management, I/O analysis, and the diagnosis of ongoing issues, effectively improving overall database performance.Implemented and maintained an archiving and purging strategy, remained on-call to provide 24x7 coverage of mission-critical systems, and provided point-in-time recovery of databases.Restored databases to troubleshoot issues with the application, and participated in monthly maintenance window and release updates established by in-house developers.

Monitored the database to ensure continual availability and optimal performance in support of the application. Ensured associated hardware resources were properly allocated to databases, resulting in high resilience and performance tuning.Served as a technical project manager and managed project teams while running scrums as dictated per project scope. Monitored database systems to minimize downtime, troubleshot and resolved SQL and Oracle development issues, and improved and maintained the database, including rollouts and upgrades.Implemented and released database changes per established timelines and costs.Accurately tested programs and databases, correcting errors and modifying prior to production deployment.Performed database tuning to keep database in shape by analyzing long / slow running queries.Troubleshoot blocking issues and deadlocksPerformed data partitioning for history tables.Prepared reports using SSRS as requested by financial department.Planned, coordinated and implemented security measures to safeguard data in automated files against accidental or unauthorized damage, modification or disclosure. Configured SQL mirroring.Setup database backup and recovery procedures for production, UAT and DEV environments.Ensured SLAs were intact and upgrades / patches were delivered in timely manner.Created and modified stored procedures, triggers, views, functions and indexes to improve performance.Prepared weekly, monthly database performance reports by comparing baselines.Automated regular DBA tasks.Involved in change management and process management before implementing changes in production and development environments.Safeguarded production systems by implementing optimal security policies, and managing MS service pack/hotfix deployments, and set preferences for various ad hoc requests and task allocation.Developed C# scripting and packages, and designed/developed OLAP cubes and dimensions using SQL server analysis.

Expertly reviewed, evaluated, designed, implemented and maintain MS Dynamics (Great Plains), and Infosys application support new enterprise-level replacement applications, accurately identifying data sources, constructing database diagrams, providing data flow diagrams, and documented all processes for clarity and records management.Authored code for databases, modifications and construction in addition to administering and maintaining all production database servers for over 150+ databases.Managed projects, directed team performance and ran scrums to meet corporate initiatives. Analyzed processes and developed procedures to continually monitor database activity and identify/resolve potential performance issues while testing database backups for disaster-recovery processes. Developed infrastructure for both transactional applications and reporting, and developed and maintained a backup and recovery strategy for all databases utilizing SAN technology.Successfully created and formatted Crystal reports, deploying through Business Objects.Designed, created, tested and implemented SQL stored procedures. Wrote stored procedures, views, triggers and functions as needed.Identified slow running queries and tuned them by adding indexes, and making changes to stored procedures, triggers and functions.Performed monthly database refresh for Test, DEV and QA environments.Set up maintenance tasks such as index maintenance, backup jobs, consistency checks, database integrity checks and provide security of databases.Created SSIS packages to import and export data.Involved in database capacity planning, database normalization and de-normalization.Implemented table partitioning.