SUMMARY:

• Responsible for ensuring the database technical and functional designs meet business requirements. A hands - on Experience with Migrated database from SQL 2005 Database to SQL 2008, SQL 2012, 2014 and 2016 as well as performed administrative tasks like database files management, backup/restore, security management, data integration
• Microsoft SQL Server 2008/2014 Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and SQL 2012 Always ON.
• 6+ years of DBA experience in SQL Server
• Installed and configured SQL Server 2005, SQL server 2008, SQL server 2008R2, SQL Server 2012, 2014 and 2016 on Windows Server 2003, Windows Server 2008 and Microsoft SQL Server 2016 and Windows Server operating systems
• Windows Server 2008R2, applied service packs and security fixes.
• Configure and Maintain Always On HA on SQL Server 2008R2
• Responsible for a large scale of database migration from SQL server 2005 to SQL server 2008, SQL server 2008R2 and SQL Server 2012,2014 and 2016
• Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Moved data from flat file, Excel, Oracle, MS Access, OLEDB Data Sources to SQL Server
• Providing 24x7 dedicated On-Call productions supports for SQL Server problem resolution and server outages.
• Involve in creating Logical & Physical Database Design.
• Responsible for configuring and maintaining transactional replication in different environments.
• Responsible for configuring and maintaining Database Mirroring & Log Shipping
• Using Lite Speed ensuring all the databases are backed up on the regular basis and restoring databases as requested.
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Improving database performance using SQL Profiler, Trace Flags, Execution plan and DTA.
• Working with installation, configuration and creation of SSRS
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0
• Deployed Reports and managed security of report server including folder level
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• SSIS Package create, deploy and manage
• Strong experience on user management, assigning permissions & roles
• Working with SSIS and DTS package to import & export operations in and out of the SQL Servers. Working with Central Management Server
• Development and debugging experience SSIS, SSAS, and SSRS
• Strong knowledge of SQL Server 2005-2016 administration.
• Experience working in large, complex environment with more than 15 production servers
• Facilitate SSRS and SSIS package deployments.
• Experience & Responsible for multiple migrations and upgrades (In place and side by side) from SQL Server to SQL Server.
• Experience in Subscribing the Azure subscription and setting up Azure for Organization.
• Experience in create and configure PASS and IAAS.
• Experience in create and manage SQL Server AZURE databases.
• Experience in creating storage account with blog, table and queue.
• Experience in creating and configuring Azure directory.
• Configure Geo-Replication for SQL Server Azure databases.
• Experience on creating the VM machine in SQL Server AZURE and configured the Transaction replication from Physical server to Azure SQL Server database.
• Experience on migrating the physical servers to Azure databases.
• Experience and migrated the SQL Server 2012 and 2014 to SQL Server 2016 Azure with Always On Availability groups.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability include Always On, Replication (Snapshot, Transactional and merge), Clustering (Active-Active and Active Passive), Log shipping and Database Mirroring (Sync and Async)
• Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports.
• Managed all data related aspects of multiple directory projects through various stages of production.

TECHNICAL SKILLS:

Database (RDBMS): SQL Server

Data Modeling: SSDD (SQL Server Database Diagram), Toad Data Modeler, Erwin

High availability: Log shipping, Replications, Mirroring, SQL clustering, Always on availability Performance Monitoring Tool Profiler, DMV, Activity Monitor, Execution Plan, PerfMon, Extended EventDatabase Tuning Advisor

Reports Development/Management: SSRS, MS Access, Excel

SQL Database Tools: SQL Profiler, SQL Agents, SQL Alerts, SQL Jobs, Database Mail, Query AnalyzerQuery Execution Plan, Counter

ETL Tools: DTS, SSIS

Operating System: Microsoft Windows Server 2008 Windows XP/vista/Win7&8, 10, Cloud Computing

PROFESSIONAL EXPERIENCE:

SQL server Database Administrator/Developer

Confidential

Responsibilities:

• Migrating database using different tools (copy database wizard, detach & attach, SSIS, etc) and data conversion and managing orphaned users
• Installed new SQL Servers, upgraded and configured MS SQL Server 2005 2008R2 and 2012
• Implement Disaster Recovery and High Availability plans such as Log-Shipping, Database Mirroring, Replication, SQL server clustering and Always-On
• Checked databases/servers are healthy and functioning as expected; look at unusual error log messages and do root cause analysis.
• Security enforcement and proper documentation of changes
• Created Database Maintenance Plan for database Integrity Checks, Updated Database Statistics and index rebuild as well as index reorganize
• Experience with SQL Development for MSSQL Server.
• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Knowledge of ETL processes and options for MSSQL Server.
• Experience working in large, complex environment with more than 15 production servers
• Facilitate SSRS and SSIS package deployments.
• Experience & Responsible for multiple migrations and upgrades (In place and side by side) from SQL Server to SQL Server
• Experience in Subscribing the Azure subscription and setting up Azure for Organization.
• Experience in create and configure PASS and IAAS.
• Experience in create and manage SQL Server Azure databases.
• Experience in creating storage account with blog, table and queue.
• Experience in creating and configuring Azure directory.
• Configure Geo-Replication for SQL Server Azure databases.
• Experience on creating the VM machine in SQL Server Azure and configured the Transaction replication from Physical server to Azure SQL Server database.
• Experience on migrating the physical servers to Azure databases.
• Experience and migrated the SQL Server 2012 and 2014 to SQL Server 2016 Azure with Always on Availability groups.
• Migrating an existing on-premises SQL server database to SQL Azure
• Experience completed a schema migration via SQL managements studio(SSMS) Migrating data via SSIS.
• Experience In backup and restore and creating a schedule to back up in SQL Azure
• Expertise in implementing efficient Disaster Recovery Strategies and High availability include Always On, Replication (Snapshot, Transactional and merge), Clustering (Active-Active and Active Passive), Log shipping and Database Mirroring (Sync and Async)
• Experience in implementing operational automation using scripts.
• Knowledge of indexes, index management, and statistics
• Writing new T-SQL queries. Tuning existing T-SQL queries to improve performance.
• Performed performance testing on stored procedures, indexes, and triggers.
• Developed Reports for different purposes using SSRS and Report Builder
• Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User Defined Data Types and Functions
• Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules
• Developed Database Backup Scripts and automated this process/tasks using SQL Server Agent Service
• Transferring Jobs and Logins using SSIS from SQL server 2005 to 2008.
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
• Configured transactional replication between OLTP server and report server.
• Performed various disaster scenarios and also documented the recovery steps.
• Used Windows Performance monitor and SQL Profiler to optimize queries, resolve deadlock issues and enhance the performance of database servers
• Extensively documented all the databases, database objects, jobs and the changes made to the database
• Used extended Stored Procedures for creating alerts for critical production jobs
• Worked as part of a team and provided 7×24 support when required

Environment: Windows server 2008R2 Enterprise edition, MS SQL Server 2008/R2, 2005 Enterprise edition, SSRS, SSIS, T-SQL, ETL, Visual studio, MS Access, Excel, SQL Profiler, Windows

Confidential

SQL Server/ DBA

Responsibilities:

• SQL server Installation and maintaining SQL servers 2014, 2012, 2008R2, 2005.
• Applying patches on both production and non-production servers.
• Database creation, database refreshes, alert monitoring and Backup script creations.
• Database migration from SQL 2008 R2 to SQL Server 2012 and 2014.
• Supporting multiple customers and providing as per business solutions.
• Having good experience on implementing and managing Always on feature on SQL server 2012.
• Have configured log shipping and as per customer requirements.
• Checking the database data files and log files is located specific drive and observe the available free space.
• Addressed the Replication Issues and have settled up the new replications.
• Patching all the DB Servers to the Latest Service Pack levels periodically to be Compliant with the Microsoft Support.
• Database refreshes from production backup to non-production servers.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Experience in using DMV and dynamic management functions to find out long running queries.
• Experience in setting up two node Active-Active and Active-Passive clustering.
• Created the SQL Server Integration Services (SSIS) Packages for exporting the data.
• Implemented SQL Server new feat users like Policy Based management, Performance Data Collector and Transparent Data Encryption (TDE),
• Configuring database mail for SQL server alerts.
• Checking Alerts and resolve issues to take appropriate action as need.
• Configuration and troubleshooting issue in Database mirroring.
• Managing user creation and providing permission as per user's requirements.
• Set up linked servers and troubleshooting any issues related to ODBC connectivity.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks
• Responsible for trouble shooting failed jobs and Replication Related issues etc.
• Monitoring the Scheduled jobs and fixing the failed jobs.
• Checking Fragmentation and Resolving Fragmentation issues.
• Rebuilding the indexes at regular intervals for better performance.
• Participate in meetings and partner calls regarding support issues and processes on weekly basis
• As a part of the DBA team providing 24x7 production support to the clients.

SQL server Database Administrator/ Developer

Confidential

Responsibilities:

• Installed, upgraded, configured and administered Four-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment. Installed and configured SQL server 2014, and migrated data from SQL server 2012.
• On routine basis was responsible for providing 24 X 7 critical production supports to numerous production, development and clustered servers.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Experienced working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• Rebuilding /reorganize and monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters, implementing Point-In-Time Recovery solutions.
• Extensively used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Used the DBCC commands for maintaining database, indexing, and validation operations, enabling trace flags or removing DLL from memory.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Used signed modules extensively for encrypted stored procedures, functions, triggers and assemblies.
• Very well versed working with different types of backups like Full, Differential and Transactional log backups.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Monitoring of database size and disk space in Production, Staging & Development environments.
• Day-to-Day administration of SQL Servers on Standalone and Cluster Environments.
• Created and maintained various logins and managed security of the database based on the required access
• Responsible for monitoring and making recommendations for performance improvement, troubleshooting, planning and migration in hosted databases. This involved index creation, index removal, index reorganizing, index rebuilding, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio, and troubleshooting with connectivity, security and firewall issues.
• Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports; Developed Database Dictionary.
• Expert in implementing the snapshot isolation and DDL triggers.
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training
• Expert in using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

Confidential

SQL Server/ DBA

Responsibilities:

• Involved in complete database design including conceptual, logical and physical models
• Installed, Configured, and Managed SQL Server 2005, 2008, engine and reporting service.
• Configured and maintained the Transactional replication in the production environments.
• Scheduled database maintenance tasks to improve the database performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Upgraded database using in place and side by side method.
• Responsible for Database Backup, Restore and Point-in-Time Recovery.
• Data modeling using Toad Data Modeler and Visio.
• Rebuilding/reorganizing the indexes at regular intervals for better performance.
• Involved in maintaining database with maximum database availability, resolve any database issues.
• Migrated and tested DTS packages, Export & Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS
• Tuned and configured the production and development database servers.
• Created the stored procedures, views and scripts
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Experience with DBCC commands, to check physical and logical consistency of the databases.
• Apply service pack and hot fixes and solving the Bugs Reflected by the Testing team
• Expertise in database Performance tuning.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Managed Database security
• Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/ Check), Views, Stored Procedures, Triggers
• Configure and maintain Database mirroring, Log shipping.