SUMMARY

• Strong Experience in MS SQL Server, MySQL, Oracle and MongoDB database development and administration in enterprise production and other environments including installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning and troubleshooting.
• Having 8+ years of experience in Database Administration and Development for large and complex databases of SQL Server 2019/2017/2016/2014/2012/2008 R 2/2008/2005/2000 in variety of environments and sectors.
• Proficient with SQL Enterprise Manager, Query Analyzer, Management Studio, Business Intelligence development studio, rescheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. OLAP, OLTP, Data warehouse design, trouble shooting.
• Experience in implementing SQL Server security and Object permissions like maintaining creation of users, assigning roles to users and creating Active Directory Groups (AD Group) and SQL authentication.
• Cloud - Azure/AWS experience in Azure VM, Azure Managed Instance, Azure SQL DB and AWS RDS and EC2 environments
• Designed and implemented and deployed multiple applications utilizing AWS Stack (EC2, S3, RDS and IAM).
• Experience in constructing T-SQLand Oracle PL/SQLTables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per teh business rule.
• Experience with software development life cycle (SDLC) and project management methodologies. Plus, proficient with third party SQL tools: Lite Speed, SQL Compare, Net backup.
• Resolving teh Disk space issues and finding teh root cause and implementing permanent fixes.
• Expertise on Develop DML /DDL scripts for business requirement.
• Verifying and resolving teh SQL Server Blocking issues, Dead lock, memory, log issues and finding teh root cause and implementing teh permanent fix.
• Experience in applying teh Service packs and Cumulative packs for servers.
• Good experience with implementing High-Availability of database servers using Always on, Replication, Log Shipping and Database Mirroring.
• Establishing weekly maintenance plans such as Integrity check, rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run teh databases efficiently.
• Extensive experience with Storage Capacity Planning, scaling, including system storage allocation, on-going capacity analysis and planning future storage requirements.
• Develop and implement policies and standards for preserving teh integrity and security of data
• Solid experience as MS SQL Server DBA with excellent T-SQL coding and testing: UDF, views, DMVs, triggers, cursors, stored procedures, etc.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, always on, log shipping, disaster recovery.
• Configuration different types of Always on like Synchronous (high protection and high availability) and Asynchronous (high performance).
• Extensive experience with data modeling, logical and physical database design using Erwin and ER Diagrams.
• Extensive experience with hardware/software consulting &service. Network logical/physical design/modeling and maintenance. In depth knowledge of TCP/IP network configurations, opening ports, planning, scaling, implementation and optimization.
• Monitoring teh Memory utilization and CPU utilization on Server level and Database loading time.
• Extensive experience on Data loading, Data Modeling, Data Extractions and Data Encrypting.
• Good in Data warehousing concepts and components.
• Expertized Migrated/Upgraded SQL Server 2000/2005/2008/2012 databases to SQL Server 2005/2008/2012/2014 databases including DTS to SSIS migration.
• Excellent skills in Information System planning, development and implementation on RDBMS and TFS.
• Provided on-call 24x7 database support and troubleshooting for on-premises and in-cloud/AWS MS SQL Server databases.

TECHNICAL SKILLS

Operating Systems: Windows 2019/2016/2014/2012 and 2008

Languages: C#.Net, SQL, T-SQL, PL/SQL, Power Shell, Shell scripting

Web Technologies: HTML, DHTML, XML, XSLT, informatics.

Databases: SQL server 2019/2017/2016/2012/2014/2008 R2/2008/2005, MySQL, PostgreSQL, Snowflake, MongoDB

SQL Server Tools/Utilities: SSMS, Query Analyzer, SQL Profiler, SQLCMD,BCP,DTS, SSIS, SSRS, SSAS, Visual Studio

Reporting Tools: SSIS, SSRS, Cosmos, power BI, SharePoint Portal and Excel.

Monitoring Tools: SolarWinds, LightSpeed, Fog Light, Service now, new relic and Jira

PROFESSIONAL EXPERIENCE

Confidential - Dublin, CA

SQL Server Administrator/ DBA Engineer

Responsibilities:

• Installation of SQL Servers with new releases and cumulative patches
• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Migrate SQL Databases from on-Prime to Azure VM\Managed Instance and AWS EC2\RDS cloud server instances.
• Migrated SQL server SQL Server 2019,2016,2914,2012 and 2008 to in Microsoft Windows Server 2019 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server SQL .
• Snowflake deployment in stage and production servers
• Mongo DB administration on-prime and AWS cloud EC2 environment
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / Monitoring teh indexes at regular intervals for better performance.
• Recovering teh databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing teh snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: SQL Server 2019/2012/2008 Enterprise, Windows Enterprise Server 2016,2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services.

Confidential - Mission Viejo, CA

SQL DBA

Responsibilities:

• Working in a 7 DBA team as a SQL server DBA, wrote SQL scripts,
• Created SSIS packages for ETL purpose and generated teh reports for teh users. Installation of SQL Servers with new releases and service packs
• Cluster Server builds, load balancing and adding drive dependencies, DBA for SQL Server 2016\2012\2008 in production, integration and development environments.
• Installation of DBA tools TSM, Autosys, Precise, and SQL LightSpeed.
• PostgreSQL administration and deployment in stage and production servers
• Restoration of databases with teh latest backups from tape drives. Worked on Precise for Server performance history.
• Execution Production releases request, Scheduling teh Jobs for stable maintenance.
• Created database objects Tables, Views, Synonyms etc. Implemented teh different types of constraints (Primary key, foreign key, unique key etc) on tables to avoid data discrepancies and enforce teh integrity of data.
• Created complex stored procedures, functions using joins for application following SQL standards.
• Created stored procedures, SQL Scripts using Dynamic SQL. for teh development of ETL Component using SSIS accordingly for Initial and Incremental Load process.

Environment: SQL Server 2008, 2012, 2016 on Windows 2010 Server, SQL LightSpeed 4.5, MSE, VSS and Password Updater.

Confidential

SQL DBA

Responsibilities:

• Installation of SQL Servers, with new releases and service packs
• DBA for SQL Server 2008,20012 in Dev, Test and production integration and development environments.
• Installation and operational of DBA tools TSM, AutoSys, Remedy, Precise, and Sql Lite.
• Worked on Legato tape backups
• Restoration of SQLite backups and Backup teh databases with SQLite.
• Worked on Precise for Server performance history.
• Execution of PRRs (Production releases request) in time.
• Scheduling teh Jobs for stable maintenance.
• Suggested and implemented various new server settings to enable a Stable environment.
• Created different type of linked servers in SQL Server.
• Set up security roles, SQL accounts.
• Created maintenance plans for Production, Integration and Development databases.
• Installation of Clustering and Replication.
• Experience on project management for strategic and long-range planning.
• Experience on setting up Standby server.
• Troubleshooting of windows server-oriented problems
• To provide 24x7 production support for SQL Server databases
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring teh data (ETL) to Data warehouse by SQL Server 2008 Integration Services.
• Rebuilding teh indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Designed and created databases, tables, views, store procedures and triggers.

Environment: SQL Server 2008, 2012 on Windows 2010 Server, SQL LightSpeed

Confidential

SQL Server DBA\Developer

Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdreport templates, bar graphs and pie charts based on teh financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back-end data validation testing.
• Checked teh configuration and performance of teh existing databases including data file allocation, index fill factor, fragmentation, and teh impact on system performance.
• Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Developed and created teh new database objects including tables, views, index, stored procedures and functions, advanced queries and updated statistics using Query Analyzer and Enterprise Manager on teh existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into teh databases.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet teh performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements