SUMMARY:

• Wide - ranging experience in SQL Server Database Management System in the areas of Database Administration, Reporting, Data Modeling(using native and 3rd party tools like Erwin), Design & Development, Advanced Installation, Backup and Recovery, Service Pack (SP), SQL/T-SQL, Stored Procedure, Trigger, Function, Views, DMV, DBCC, Clustering, Configuration and management of Always On, Log Shipping, Mirroring and Replication
• Solid experience in Database Performance Tuning using SQL Server Profiler, Extended event, Database Engine Tuning Advisor, Execution plan, Performance Monitor and other third party tools named RedGate, SentryOne, OpNet, and SolarWinds
• Expertise in working on multiple data modeling projects including gathering, analysis, conceptual, Logical and Physical data modeling Backward and Forward Engineering using native tools and third party tools like ERWin, Toad Data Modeler, SSDD together with versatile knowledge in SQL/T-SQL scripts for managing Database and database objects
• Hands on experience in managing Security by defining Roles and Rights and an expert in Data Masking using native and third party tools like DataVail and Informatica.
• Solid experience on Normalization, De-normalization, Index, Index-Partitioning, Locks, Deadlocks, SQL Transactions, Isolation Levels, Pivot Operator, Merge, Joins, Cursor, Error Handling in SQL Server, Union and Union All.
• Hands on experience 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
• 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
• Design, create and modify cubes using SSAS 2012, 2014 & 2016, deploy/processing the cubes for creating OLAP database and perform analysis by connecting the cubes in SSAS Server.
• Upgrade and migrate:-Upgraded and migrated from SQL Server databases and instances from older version to newer version such as SQL 2002/2005 to SQL Server 2012/2014 of different environments
• Hands on experience at Migrating Databases from Oracle to SQL Server using SSMA.
• Solid working experience on Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2
• Configured and managed High Availability and Disaster Recovery solutions namely Log shipping, Mirroring, Replication, SQL Server clustering and AlwaysOn
• Experience in creating, supporting and maintaining database administration scripts
• Manage Security Management: Securing SQL Servers and Databases, Manage users, Data encryption, granting/revoking access
• Extensive work experience in Compression, Database maintenance and Optimization
• Ability to adapt in changing environments
• Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload
• Performed on call support duties as well including other maintenance related support
• Effective communication, multi-tasking and prioritizing skills, excellent interpersonal skills, strong customer focus, quick learner, reliable and dependable

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

SQL Database Administrator/Developer

Responsibilities:

• Installed, Configured, and Managed Instances and Databases in SQL Server 2014, 2012, and 2008R2 in development, Training, Staging, Test/UAT, and Production Environment
• Installed, Configured and Maintained HA (High Availability & Disaster Recovery) Solutions such as AlwaysOn, FailOver Clustering(High Availability Only), Replications, Mirroring, and Log Shipping
• Installed, Configured, and Managed Instances of SQL Server Reporting Services (SSRS)
• Developed, Deployed and Managed Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Upgraded/Migrated SQL Server and Reporting Server Instances
• Applied SP (Service Packs) and Hot fixes
• Migrated Databases and Instances
• SQL Server to SQL Server
• Oracle Databases to SQL Server
• MySQL Databases to SQL Server
• MS Access Databases to MS SQL Server
• Monitoring, Troubleshooting Instances, Databases, Queries using different tools
• Query Execution plans
• Database Tuning Advisor
• PerfMon
• Server Logs, Agent Logs and Error Logs, Event Logs
• DMV (Dynamic Management View)
• Profiler
• Indexing, Index and Statistics Management
• Developed and Tune-up Queries
• Queries including JOIN, Stored Procedures, Functions and other queries
• Worked developers to tune-up queries related to performance issues
• Database Design
• Designed new database systems for applications and redesigned existing database systems
• Designed Relationship, Keys, constraints, indexes, and other constraints for data integrity and performance
• Conceptual, Logical and Physical Design
• Backward and Forward Engineering
• Used native and Third Party tools - ERWin, Visio, Toad Data Modeler
• Database Architecture - Solid experience on architecting Database Server Instances
• Automations - Create jobs, setup schedules, configure mail server, operators, notifications and other related services
• Database Backup - Designed backup strategies for development, Training, Staging, Test/UAT, and Production Environment, setup automated backup verification process for backups
• Database Recovery, Refresh and Deployment - Performed Database Recovery, Refresh/Deployment across the environment including Point-In-Time Recovery
• Data Masking, Encryption (TDE: Transparent Data Encryption)
• Monitoring database and server health, lock, block, disk, CPU, jobs and other related services
• ETL Processing
• Installed, Configured, and Managed SSIS (SQL Server Integration Services) Instance
• Developed, Deployed and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel and OLE DB supporting sources
• Migrated and Upgraded SSIS Packages
• Setup jobs using SSIS Packages
• Managed security
• Used SSIS packages for many other purposes - Moving logins, databases, data, and for other objects,
• Instance, Databases, and Users Security Management

Work Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2014, 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases

Confidential, Richmond, VA

SQL Database Administrator

Responsibilities:

• Migrated and Upgraded from SQL Server 2005, 2008/2008 R2 to SQL Server 2012
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Managed High Availability Solutions in Database Clustering, Mirroring, and Log Shipping
• Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Developed, tested & implemented database backup and recovery strategy with client assistance.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures and developed & executed script changes requests in accordance with change control procedures.
• Set up security and access profiles and procedures for database system administrators.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
• Data Masking, Encryption (TDE: Transparent Data Encryption)
• Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
• Managed security by defining roles and rights.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.
• Installed and Configured SQL Server Reporting Services (SSRS)
• Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition
• Expertise in database Performance tuning
• ETL data processing using SSIS
• Working individually, as a member of a team, and lead small teams to design and model systems at a high level prior to construction

Confidential

SQL Database Administrator/Developer

Responsibilities:

• Configured, Installed, and Maintained SQL Server 2000 & 2005 in development, test, and production environment
• Installed and Configured Operating Systems, Windows Server (2000 & 2003)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment
• Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition
• Expertise in database Performance tuning
• Writing T-SQL and Stored-Procedures
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP
• Generated Report using SSRS and in Excel, html, text from Database as well
• Working experience in Database Backup, Restore and Point-in-Time Recovery
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, Error Log, space usage, and solving problems needed

Working Environments: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases