SUMMARY:

• SQL Server Database Administrator about 7 years of experience in different version (2005/2008r/ 2012/2014/2016 ) of SQL Server in Health Care, Investment Banking and industries is seeking SQL Server DBA position.
• Experience entails different aspects of SQL Server Database Administration including Installation, Database Migration, Backup, DR & HA Solution, Performance Tuning, Maintenance Plan, Automation Jobs, Security, Data Modeling, SSRS, SSIS for different SQL Server version on different Operating Systems.
• Well - versed in using third-party database management tools, as well as various database objects such as stored procedures, triggers, functions, Index, constraints and views etc.

TECHNICAL SKILLS:

Operating System: Windows Server 2012, 2008r2, 200, VMware

Database Administration: SQL Server 2016/ 2014/2012/2008 R2/2005, MS Access 2007 and 2003

Database Migration: Oracle (10gr2, 11gr2)/ My-SQL 4.0.3/5.0.15 databases to SQL Server

ETL Tools: BIDS/SSDT

Performance Tuning Tools: Query Execution Plan, Profiler, Database Tuning Advisor, Activity Monitor, Perfmon, SQL Server/Agent Error Log, Idera

Reporting/Analysis Tools: SSRS, Crystal Report

Data Modeling Tools: Erwin, VISIO, Toad Data Modeler

Scripting Tools: PowerShell, Query Analyzer

Programming Languages: Worked in C#, Java, ASP.NET, HTML, and XML Environment

Networking Related Expertise: Managing User accounts using Active Directory, Implementation of TCP/IP, Configured workstations for IP based LAN TCP/IP, DNS, SMTP, and HTTP, Configured IIS 7.5

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, Virginia

SQL Database Administrator

• Install, Configure, and Manage SQL Server 2005, 2008 R2, 2012, 2014,
• Implement 2016 in Test environments
• Apply Service Packs/Hot Fixes on SQL Server
• Upgrade from SQL Server 2008R2 to SQL Server 2012 and 2014
• Migrate MS Access, Oracle 10g, MySQL 5.1.23 RDBMS into MS SQL Server
• Document the process of installation, apply service packs, upgrade and migration step
• Experience in Disaster recovery through backup/restore, point-in-time recovery
• Refresh Database as needed
• Configure and maintain HA options (Log shipping, mirroring, replication, clustering, Always On)
• Schedule jobs and create alerts as needed
• Create Server logins, database users
• Implement Transparent Database Encryption (TDE)
• Configure Tempdb for better performance
• Configure Table Partitions to improve I/O access and performance
• Data compression and Shrink database as needed
• Monitor (Memory, CPU, Disk Utilization, I/O, Blocks, Deadlocks, Fragmentation, Long running query) to optimize database performance
• Rebuild, reorganize Index and update statistics at regular intervals
• Use DBCC and DMV to check database condition and consistency
• Experience in creating and modifying Indexes (Cluster/Non-Cluster), Constraints (Unique/Check) and Views
• Assist Database Developers to Optimize SQL queries and Stores Procedures.
• Write Ad hoc Transact-SQL scripts for reporting and maintenance
• Execute PowerShell Script to maintain the server and database
• Generate Ad-hoc Reports, Manage Reports Security, and deploy reports using SSRS
• Create Ad hoc package, configure different level of security and deploy package using SSIS
• Resolve issues reported by customers
• Administrate SharePoint

Environment: Microsoft Windows Cluster Server, Windows Server, .Net, XML, SQL Server Management Studio, Query Analyzer, Performance Monitor, SSRS, SSIS, MS Visio

Confidential, Long Island City, NY

SQL Database Administrator

• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Installed, Configured and Managed SQL Server in Development, Test and Production environments
• Implemented and Maintained High Availability solutions, including Log Shipping, Mirroring, Replication and Clustering
• Developed, Deployed and Managed Reports using SQL Server Reporting Services
• Installed, Configured and Maintained SSIS for ETL processes and configured different levels of security in SSIS packages
• Upgraded SQL Server 2005 to 2008R2 and SQL server 2008R2 to 2012
• Database Migration from Oracle to SQL Server
• Applied Service Packs and Hot Fixes on SQL Server
• Setup automation jobs for different tasks such as monitor database health, disk space, backup verification, index monitoring and statistic monitoring
• Monitored Server Activity, Error Logs, space usage and solving problems as needed
• Created database Logins and Assign permissions to user roles, objects and Support column level permissions
• Implement Transparent Database Encryption (TDE) and Column Encryption
• Participate in data modeling projects and generated E-R Diagrams using third party tool
• Imported data from multiple sources such as Flat file, CSV file, Oracle, My-SQL
• Used DBCCs to check database conditions and database Maintenance
• Highly experienced in writing and managing T-SQL codes and Stored-Procedure as well as creating and modifying tables, indexes, Constraints, View

Environment: SQL Server 2012/2008R2/2005 with clustering, T-SQL, Windows Server 2003R2/2008R2, SSDT, Oracle, DTS, Excel, Access and IIS

Confidential, Washington, DC

Junior SQL Database Administrator

• Installed, Configured and Managed SQL Server 2008R2, 2005
• Working experience in Database Backup and disaster recovery
• Configured and Maintained Fail-Over Clustering, database Mirroring
• Maintained Snapshot and Transaction Replication
• Migrated Oracle database and MY-SQL database to SQL Server2008r2
• Implemented Upgrade SQL Server 2005 to SQL Server 2008r2
• Applied Service Pack/Fixes on SQL Server 2005 and 2008R2
• Practical work experience on Conceptual, Logical and Physical Data Model
• Maintained Logins, Roles, Authentication, Security polices and permissions to users
• Scheduled jobs to automate different task.
• Developed Maintenance Plans such as backup and restoration solutions, index management, fragmentation management, cleaning history, deleting old files
• Created and managed Index, Constraints keys (PK, FK)
• Monitored Server Activity, Error Logs, space usage and solving problems as needed
• Administered SQL Server Reporting Services (SSRS)
• Developed Ad-hoc Reports using Report Builder 3.0, 2.0
• Exported & Imported data from Flat file, CSV file to/from SQL Server Database using SSIS/DIBS

Environment: SQL Server 2008R2/2005 SSIS, SSRS, T-SQL