SUMMARY

• Have 9+ years of working experience in Microsoft SQL Server and suite products like SSIS, SSAS, and SSRS, Azure SQL, PostgreSQL, MySQL and oracle Databases.
• Excellent skill in design, develop and build database architecture for OLTP and OLAP projects.
• Expert in SQL Server installation, configuration, and upgrading of Microsoft® SQL server™ 2012/2014/2016/2019 on premise and Azure.
• Strong experience and skill in Migrating SQL Database form On - prom to Azure, configure Geo-replication for High avaialbity, Managed database on Elastic Pools and Manage instances.
• Experience on Migrating SQL database toAzure data Lake, Azure synapse analytic, Azure SQL Database, Data BricksandAzure SQL Data warehouseand Controlling and granting database accessandMigrating On premise databases toAzure Data lake storeusing Azure Data factory.
• Strong experience and skill in T-SQL programming in writing stored procedures, functions, triggers, and others.
• Advance level expertise and hands-on experience in database backup, recovery, and disaster recovery procedures and strategies using Commvault and Rubrick tools.
• Expert in implementing SQL server high availability and disaster recovery model features like SQL server always on High Availability Group, SQL Server clustering, and Replication on physical and virtual machines.
• Sound knowledge and experience in developing, deploying, and monitoring SSIS packages.
• Sound knowledge in Team Foundation server and source code control.
• Proficiency with SQL Management Studio, SQL Profiler and Performance Monitoring (Spotlight,Foglight and Sloarwinds) to generate traces, execution plans, identify performance issues, deadlocks contention and resolve them.
• Highly experienced in investigating and applying necessary MS SQL Server database Service packs, hotfixes, and Security Patches.
• Ability to work in a team environment as well as dedicated to continuous learning and improvement and well experienced on work ticket queues and document resolutions.
• A quick learner, skilled, and experienced using several programming languages, good time management, effective interpersonal communication, and efficient problem resolution.

TECHNICAL SKILLS

Database: MS SQL Server 2012,2014,2016,2019 PostgreSQL, MySQL, Azure SQL, AWS RDS, Synpase analytics, ADF.

Data modeling tools: Toad Data Modeler, SSDD, TeradataStudio.

Reporting Tools: SSIS,SSRS, Power View, Report Designer, SPSSOS Window server 2012/2012R2, 2016, Linux

Programming languages: T-SQL, PowerShell, Java, PL/SQL

PROFESSIONAL EXPERIENCE

SENIOR SQL SERVER ADMINISTRATOR

Confidential, TX

Responsibilities:

• Develop, manage, schedule, and document database projects and tasks, including security, backup, archival, & workload management.
• Install, configure, and upgrade SQL server™ 2012/2014/2016/2019 on premise and Azure environment.
• Provides application development support for Query Optimization, Stored Procedures, Triggers, Indexes, etc. for multiple development applications
• Responsible for monitoring and troubleshooting performance issues and optimize TSQL queries, stored procedures, functions, and maintenance of indexes.
• Install, configure, and upgrade SQL,MySQL and PostgreSQLon premise,AWS and Azure environments.
• Install, configure and regularly monitor high availability and diseater recovery technology for porduction databases using Always On High Availability Groups and SQL Server Replication techniques.
• Responsible for Migrating on Premises SQL Databases to Azure SQL database and Manged Instance using DMA & DMS(Offline & Online).
• Managing and configuring Virtual machines using Azure portal and creating the alerts for VMs using Azure Portal.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Create strategies for performing repetitive tasks such as data acquisitions, migrations, data recoveries, and new database implementations.
• Migrating sql database to Azure using Azure SQL Database Import and Export Service.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability involved in installation/configuration and maintenance.
• Works with System Energies to size and order new database instances within the test environment in support of Project Development work

SQL SERVER ADMINISTRATOR

Confidential, Sacramento, CA

Responsibilities:

• Install, configure and upgrade SQL server (2008, 2012, 2014, and 2016 versions) on server and client boxes.
• Develop complex T-SQL code such as stored procedures, functions, triggers, indexes, and views for the applications.
• Develop, test, and apply different security and access for database administrators and responsible for providing appropriate SQL server security /access to a client.
• Perform backup and recovery and automation of backup by developing comprehensive backup and recovery strategies.
• Responsible for monitoring and troubleshooting performance issues and optimize TSQL queries, stored procedures, functions, and maintenance of indexes.
• Regularly run DBCC consistency checks and fixing data corruption on application databases.
• Responsible for creating automation of day-to-day operations and related tasks.
• Use SSIS to create ETL packages to validate to Data Warehouse.
• Provide 24/7 OLTP, OLAP databases technical support and monitoring and schedule the monthly/weekly/daily reports to run automatically onto the dashboard.
• Work as a team with business analysts, developers, and clients in identifying the requirements and designing and implementing the database schema.

SQL SERVER ADMINISTRATOR

Confidential, Alexandria Virginia

Responsibilities:

• Installed, configured, monitored, upgraded, patched, and tuned SQL server 2008 and 2012 server.
• Created logins and adding users to respective databases and managing security tasks.
• Developed, analyzed, and tested capacity planning for maintenance of different database backups and restore scenarios.
• Responsible for monitoring and troubleshooting performance issues and data integrity.
• Responsible for data migration import, export, and BCP using SSIS and SSAS.
• Provided SQL Server problem solution and 24x7 production support and server outages.
• Work as a team with different information technology teams (Network, software, and data developer teams) and had good teamwork with stakeholders and Customers.