SUMMARY:

• An experienced Certified Microsoft SQL Server Database Administrator/BI Developer with SQL/TSQL skills having more than 6 years, who is dedicated to keep up - to-date industry knowledge looking for SQL Server Database Administrator/DBA job. Dedicated and responsive professional has experience in managing production, test/UAT, development environment, requiring minimum or no supervision and be productive from the first day of the job. Professional experience entails configuring, and managing Databases and Database Servers using SQL Server 2016/2014/2012/2008 R2/2005/2000 and Operating System Windows Server 2012, 2008 R2, 2003 R2 including Virtual and Azure Environment.
• Extensive experience in SQL Server Database Management System in the areas of Database Administration, Reporting, Data Modeling, Database Design and Development, Advanced Installation, Configuration, Backup and Recovery, Upgrade, Service Pack (SP), SQL/T-SQL, Stored Procedure, Trigger, DMV, DBCC,Clustering, Always On, Log Shipping, Mirroring and Replication.
• Proven experience in Database Performance Tuning using SQL Server Profiler, Extended event, Database Engine Tuning Advisor, Execution plan, Performance Monitor and other third party tools like RedGate, OpNet and SolarWinds.
• Configured and managed High Availabilityand Disaster Recovery solutions like Log shipping, Mirroring, Replication, SQL Server clustering and AlwaysOn.
• Experience in creating, supporting and maintaining database administration scripts.
• Expertise in working on multiple data modeling projects including gathering, analysis, conceptual, Logical and Physical data modeling using tools ERWin, Toad Data Modeler, SSDD.
• Experienced with SQL/T-SQL scripts including scripts/SQL/TSQL for managing Database and database objects.
• ETL: SSIS & DTS Packages: Created, configured, deployed, and managed including Migrate and Upgrade.
• Reports: SSRS - Highly proficient in Installed, Configured, and administered SQL Server Reporting Services (SSRS), created, deployed, managed reports including migrating reports.
• Experienced in Data Movement, data dumping using different tools like Export & Import utility, Data Tools, BIDS, SSIS, and DTS including Excel File, Flat file, CSV file, SQL Server Database.
• Upgrade and Migrate: Upgraded and migrated from SQL Server databases and instances from older version to newer version like SQL 2005 to SQL Server 2008 R2/2012/2014 in different environments. Migrates from MySQL to SQL server 2008, 2012, 2014 and 2016.Add roles, migrate table and related object using SSMA, export import, run packages, map data using SSIS and migrate from MySQL to Microsoft database and Azure SQL database.
• Sound knowledge and working experience in Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2.
• Manage Security Management: Securing SQL Serversand Databases, Manage users, Data encryption, granting/ revoking access.
• Extensive work experience in Compression, Database maintenance and Optimization.
• Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload.
• Effective communication, multi-tasking and prioritizing skills, excellent interpersonal skills, strong customer focus, quick learner, reliable and dependable.
• Cloud/Azure: experience entails Azure Services, migrated on premises databases and Legacy databases to Azure, deployed products on Azure, and setup development and test environment on Azure.
• Database Management:
• Strong knowledge and working experiences as Database Administrator of MS SQL Server (2005, 2008 R2, 2012, 2014, 2016).
• Strong work experience and knowledge in SQL Server Replication, Log shipping, Mirroring, Clustering, Performance tuning, Backup/recovery, Query Optimization, Database and Column Level Encryption, and Security Management.
• Maintain Management Plan, Job Set up and monitor job activities.
• SQL, T-SQL, Functions, Store Procedures, Trigger.
• Data Modeling: Backward Engineering, Forward Engineering.
• Worked with multiple projects in Database - Can Create Conceptual, Logical, and Physical Data Model.
• Tools used - ERWin, Toad Data Modeler, and SQL Server Database Diagrams.
• Good Understanding about Data Warehousing, Schema, OLAP.
• SQL Server Reporting Services (SSRS), visual Studio - Installation, Configuration, and Management.
• Developed, Deployed, and Managed Reports.
• SQL Server Integration Services (SSIS), DTS, BCP - Installation, Configuration, and Management.
• Developed and Deployed SSIS packages.
• Worked on Operating Systems like Windows Server 2003 R2, 2008 R2 and Windows Server 2012 including installation, and configurations.
• Virtualization: Installed, Configured, and Managed SQL Server in virtual environment using VMware and VSphere.

PROFESSIONAL WORK EXPERIENCES:

Confidential, Washington, DC

Database Administrator

Responsibilities:

• Cloud/Azure: Migrated on premises databases and Legacy databases to Azure, and setup production, development and test environment on Azure.
• Moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Managed Database Servers in Development, Test, and Production environment.
• Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014, 2016 in Development, Test, and Production environment.
• Installed, Configure and Maintained HA/DR Solutions using Clustering, AlwaysOn, Mirroring, Replication, and Log Shipping.
• Installed, Configured monitored and troubleshoots Log Shipping as Standby database from Production database for Reporting purposes.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS).
• Developed and deployed different type of repot using different data source like SQL Server, Oracle, CSV, and Excel.
• Delivered reports to users in variety of format like Report Server (Web Based), Excel, CSV, PDF formats.
• Database Upgraded and Migrate (development, testing and production environment)
• Upgraded/Migrated SQL Server 2005 to SQL Server 2012/2008 R2 & 2012 to 2014/2016
• Migrated MS Access Database 2000, 2003 into SQL Server 2008 R2, 2012.
• Migrated Oracle 10gR2/11gR2 and My SQL 5.1.23 Database to SQL Server 2008 R2/2012.
• Good understanding on data modeling projects and generated E-R Diagram.
• Data modeling tools used: Toad Data Modeler, SQL Server Data Diagram.
• Backward & Forward Engineering with data modeling tools mentioned above.
• Applied SP/ Hot Fixes (Service Pack) on SQL Server.
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.
• Enable SSL or IPSEC for connections enable password policy checking. Implement Transparent Data Encryption to protect confidential data.
• Implement Transparent Data Encryption(TDE) encrypts SQL Server, Azure SQL Database and Azure SQL Data Warehouse data files and encrypting data at rest.
• Move a TDE Protected Database to another SQL Server
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Strong on database Monitoring and Performance tuning.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Monitor SQL Server Error Log, Space usage.
• Identifying the memory, I/O and bottlenecks, blockinganddeadlockstriggered by complex queries where using SQL ServerActivity monitor and profiler and implement better Query Execution plans.
• Strong on SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.
• Besides Native tool, used OpNet as a Third Party Tool for monitoring and Performance Tuning.
• Writing T-SQL, Functions, Trigger, Partition, View, and Stored-Procedures, joins, union and writing scripts for job set-up.
• Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using BIDS, SSDT.
• Export & Import data from/to databases as My-SQL, and Access to/from SQL Server.
• Creating SSIS Packages and deployed from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports OLEDB Data sources.
• Setup jobs from SSIS Packages.
• Data analysisand migrationby transferring and using SSIS packages.
• Skilled in creating simple, parameterized and complex reports involving Sub Reports, Matrix/Tabular Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports and drill down reports usingSSRS.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report.
• Experience withlogical and physical data modelingand database design usingErwin.
• Package Configuration,SSRS, SSASand Data-warehousing.
• Experience in Designing and Building dimensions and cubes using SQL Server Analysis Services
• Createdreport snapshotsto improve the performance ofSSRS.
• Improved the accuracy of the source data by implementing data validation on the source Data for reporting
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modelingusingERWIN data modeler
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Experienced with Point-in-Time Recovery.
• Restored Database from backups.

Environment: Microsoft Cloud/Azure, SQL Server 2008 R2, 2012, 2014, 2016 IIS 7.5, 8.5, Windows Server 2008 R2, 2012 R2, ASP, ASP.net, Java, ETL and AD (Active Directory).

Confidential, Washington, DC

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008 R2, and 2012 in development, test, and production environment.
• Installed, Configured database associated tools and performance monitoring Software.
• Setup, Configured, monitors and Maintained Database Replications.
• Installed, configured, maintain and monitored troubleshoots SQL Server Database Mirroring.
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes.
• Securing SQL Serversand Databases, Manage users, Data encryption, granting/ revoking access.
• Planning, controlling andmonitoringtheSecurityandAuditissues as per SLA and Standards.
• Data Encryption and Data Decryption for data security in Database & Column level.
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security by native tools and RedGate tools.
• Applied SP (Service Pack) on SQL Server 2008R2 and 2012
• Expertise in database Performance tuning SQL profiler, Execution Plan, Database tuning Advisor, Activity Monitor, Performance Monitor.
• Monitored data activities such as logs, space utilization, locks, long transaction.
• T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes.
• Developed and maintained scripts, utility jobs or implement needed software for database maintained.
• Created and managed Indexes, Constraints, and Keys (Primary Key, Foreign Key).
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Worked multiple Data Modeling projects for different applications
• Processed data dump and Exported & Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool.
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/Imp and DTS tool.
• Installed and Configured SQL Server Reporting Services (SSRS). Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification and moving databases from environment to environment including creating test environment.
• Developed different maintenance plans such as backups, index management, fragmentation management, cleaning history, deleting old files.
• Monitored Server Activity, Error Log, space usage, and solving problem as needed.
• Executed change management scripts on weekly basis.

Environment: SQL Server 2008 R2, 2012 IIS Server 6.5, 7.5, Windows Server 2008 R2, 2012 R2, ASP.net, Java, ETL and AD (Active Directory)