SUMMARY

• Skilled Senior Database Administrator bringing 8 years of experience in Support of application deployment and administration of databases, as well as key skills in disaster recovery, High Availability and Performance tuning.
• Experienced in RDBMS database design, performance tuning, optimization, backup and recovery. Implementation of SQL Logins, Roles & Permissions. ETL Tools: SSIS, DTS, Import Export Data, Bulk Copy Program (BCP). Upgrade, Migration of MS SQL Server and from / 2016/2017/2019 , cloud migration.
• Warehousing of data, development of enterprise architectures, and strategic collection and use of business intelligence.
• Proficient in technical software, languages and tools, and learns new strategies quickly.
• Collaborative and team - oriented wif first-rate oral and written communication, complex problem-solving, and decision-making abilities.

TECHNICAL SKILLS

• Disaster recovery
• SQL
• MySQL
• Data Warehouse
• Oracle
• Microsoft SQL Server
• Azure
• AWS
• LINUX
• SSIS/SSRS/SSAS
• Scripting
• Relational Databases
• Operating Systems
• Google Cloud Platform
• Windows
• Software Troubleshooting
• Microsoft Windows Server
• Postgre SQL
• Agile
• T-SQL
• PowerShell
• Patching
• Migration

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential | Atlanta, Georgia

Responsibilities:

• Experienced in configuring, Maintaining and troubleshooting Log shipping, Mirroring, Always on Availability Groups, replication SQL server Failover cluster on same and multiple subnets.
• Transferred data to data warehouse and exported files in various formats based on requirements using SSIS packages.
• Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
• Create the necessary indexes to improve the query performance.
• Created database objects like tables, views, indexes and stored procedures.
• Created Entity Relationship (ER) diagrams based on requirements.
• Created SSIS Packages to migrate the data from database to text files and developed SSIS packages for file transfer from one location to the other using FTP task.
• Worked on SSRS reports to report the daily, weekly and monthly statistics of various investors.
• Used reporting services (SSRS) to schedule reports to be generated on predetermined time.
• Involved in creation of various dashboards used for reporting to the end user.
• Identified and worked wif parameters for parameterized reports in SSRS 2008.
• Generated the drilldown, drill through and linked reports using the SSRS.
• Interacted wif business analysts for understanding the reporting requirements for different users.
• Expert in SSIS look up, Fuzzy group transformations and data flow tasks.
• Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into another database.
• Experience using basic SSIS tools and TABLEU for virtualization.

SQL Server Database Administrator

Confidential | Overland Park, KS

Responsibilities:

• Expert in configuring, Maintaining and troubleshooting Log shipping, Mirroring, AlwaysOn Availability Groups, replication SQL server Failover cluster on same and multiple subnet.
• Experienced in Planning and executing disaster recovery (DR) exercises on the DR servers.
• Managing permissions and security.
• I'm part of a team that manages over 1000 SQL servers in a Clinical Research environment on a 24/7 basis
• Provisioning Databases and configuring appropriate HA/DR strategy based on the RTO/RPO of the business Division.
• Build Clusters 2 node and 3node wif Active - Active and Active-Passive.
• Good hands on issues wif Always On.
• Monitoring daily, weekly, Monthly and quarterly Maintenance Task, ensuring that its successful and jumping into resolve issues when it fails.
• Creating and supporting ETL process from Oracle to SQL server, Sybase to SQL server, Access to SQL server, Excel to SQL Server.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies implemented.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in trouble shooting and fine-tuning of database for its performance and concurrency complete documentation about the database Designed and created databases, tables views, store procedures and triggers.
• Automation of repetitive task Using PowerShell.
• Weekly Patching of Standalone and Cluster instances.
• Migrating and Upgrading SQL server from Legacy to 2014, 2016, & 2017.
• Complete Administration of MS SQL Server Database is my primary responsibility increased the Server Availability time wif optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup.
• Gathering data requirements and designing and fine-tuning of database as per the requirement of clients.
• Carrying out performance tuning task on a regular basis on issues ranging from query tuning to index optimization, Temp Db issues, to IO, High CPU usage, severe blocking, long running query, always on out of sync, mirroring out of sync, log shipping out of sync.
• Responsible to follow the company guidelines / regulations to ensure company data is held in a secure manner, including electronic access or in written format.
• Experienced in configuring, Maintaining and troubleshooting Log shipping, Mirroring, AlwaysOn Availability Groups, replication SQL server Failover cluster on same and multiple subnet.
• Carrying out regular health checks across thousands of servers using PowerShell script.
• Maintaining database space issue, resolving excessive log growth issue, and Normalization of DBS.
• Worked wif other team members to implement changes to server, instance and database.
• Supporting Reporting Servers (SSRS), Integration Services (SSIS), Analysis Services (SSAS).
• Deploying changes and rolling back changes from production.

SQL Server Database Administrator

Confidential

Responsibilities:

• Configuring, Maintaining and troubleshooting Log shipping, Mirroring, Always On Availability Groups, replication SQL server Failover cluster on same and multiple subnet.
• Created and managed schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Wrote complex T-SQL queries using stored procedures, functions and views.
• Created reports in SQL Server Environment using SSRS in Business Intelligence Development Studio (BIDS).
• Worked wif the front-end developers to deploy the reports.
• Proper use of Indexes to enhance performance of individual queries for fast and efficient reporting.
• Set up and configured DB mail and created operators to send out an email whenever any SQL jobs fails.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Performed patching to maintain current versions of SQL.
• Worked on Always ON Environment.
• Implemented transactional replication and mirroring on part of Always On Availability Group.
• Actively participated in migration of databases from and 2012.
• Expertise in designing databases and capacity planning.
• Working on data mining and Microsoft analysis services.
• Analyzed results of the tested by creating reports Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Updating/Deleting File stream Data.
• Created DTS packages for migration of data from SQL Server to MS Access or Oracle Databases.
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Created groups, toles, users and assigned privileges to users.
• Exported and imported data from text files and Excel T-SQL Server database using bulk copy insert and BCP utility.
• Tune and performance of SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Scheduled jobs and alerts using SQL Server Agent.
• Environment: MS SQL Server 2008/2008R2/2012, T-SQL, Business Intelligence - MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, Database Mail.
• Worked on SSIS packages for transferring data from various data sources like MS Access and Excel.
• Exported and imported data from text files and Excel to SQL Server using Bulk Insert and BCP utility.
• Worked wif development team to optimize schema and performance.
• Worked under Active/Passive and Active/Active cluster environment.
• Installed and configured SQL Server 2008 and 2012 on Windows server 2008.
• Designed SSIS packages to extract data from various OLTP sources, Text Files, XML Files, Excel and MS Access to OLAP system like SQL Server.