SUMMARY:

• More than 9 years of IT experience in MS SQL SERVER and MYSQL Database Development, Programming, System Analysis, Design, and Administration & Support in Production, QA, Replication, Cluster Server, and High Availability Environments.
• Experience in installation and configuration of MS SQL Server 2014/2012/2008 R2/2005 versions.
• Experience in Migration from SQL Server 2000 to SQL Server 2005/2008 R2/2012 and 2014 as well as Confidential Exchange tool for migrating Confidential packages to Confidential packages.
• Experience in Migrating the Databases from Physical Sql Server instances to Amazon RDS SQL Server Instances.
• Experience in up gradation/Migration of MS SQL Server 6.5/7.0 to MS SQL Server 2000 and now, 2008,2012 and 2014 by in place upgrade process and Side by Side process
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and Confidential utility. Extracting, Transforming, and loading of data using SQL Server Confidential .
• Experience in IIS, MTS, and Windows NT administration.
• Experience with upgrades and service pack installations Tuning and normalization.
• Expertise in planning and implementing MS SQL and MYSQL server security and database permissions
• Experience in Database Backup, Recovery, and Disaster Recovery procedures on the Physical servers and also on the Amazon RDS Cloud Services.
• Extensive experience with Storage Capacity planning, including system storage allocation, on - going capacity analysis and planning future storage requirements. Hands on experience and outstanding knowledge in high availability solutions, including SQL Server Always on, Clustering, Replication, Log shipping and Multi-AZ Deployments for Microsoft SQL Server databases with Database Mirroring using Amazon RDS.
• Managed the multiple databases (DB) under clustered (active/active, active/passive) and implementing RAID technology.
• High level proficiency with various types of Replication Models such as Snapshot, Transactional, Merge Replication, Row-Based Replication, and Statement Based Replication (Planning, Replication Tools, Implementing Replication) in MS SQL and MYSQL.
• Extensive knowledge of Relational Database Management Systems.
• Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services ( Confidential ), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment.
• Proficient in monitoring SQL Server Performance using SQL Profiler (Deadlocks/Long running queries), Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard, and Windows Performance Monitor.
• Good experience in monitoring Windows and SQL Server error logs.
• Experiences in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC, resolve Deadlocks/Long running queries.
• Design entity relationship diagrams and dimensional data models.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views using SSMS and SQLCMD.
• Proficiency in web-tier development using HTML -proficiency in middle-tier and backend programming using SQL.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers through query analyzer
• Experience in implementing business logic using Triggers, Views, and Stored procedures.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.
• Supported the deployment of SQL Server 2005/2008 and Confidential (Integration Service for ETL activities).
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( Confidential ), Log Shipping, Confidential, Bulk Insert and BCP.
• Created Confidential and Confidential Package designs for Import/Export from accesses, oracle to SQL Server.
• Self-motivated and Flexible to adapt to any new environment and work on any project.
• Worked as a team member to provide 24x7 on-call production database support.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/2005/2008/2008 R2,2012 and 2014, MS Access, My SQL, Postgres, SQL Azure, and AMAZON RDS.

Database: SQL Management Studio, BIDS, T-SQL, SQL Profiler, Crystal Reports

Technologies/Tools: 9.0/10, Confidential (ETL), SSRS, SSAS.

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, VB.Net and Python.

Scripts: JavaScript, VBScript, PowerShell, HTML, XML

Tuning and Monitoring Tools: Perfmon, SQL Profiler, Dell Quest, Foglight, Nagios and Percona.

Operating Systems: Windows Server 2003/2008/2012 , Linux 3.2.0,UBUNTU

Web/App servers: IIS 5.0/6.0/7.0, Hyper-V, Sharepoint

Backup Tools: Symantec NetBackup and LiteSpeed.

PROFESSIONAL EXPERIENCE:

Confidential, WA

Database Administrator

Responsibilities:

• Implemented and supported MySQL, Postgres and MSSQL high availability and disaster recovery database solutions.
• Optimized MySQL and MS SQL database performance.
• Installed, configured, administered and secured SQL Server 2008, 2012 and 2014 databases.
• Estimates database capacities; develop methods for monitoring database capacity and usage.
• Use to Collect the necessary information from Application Owners and the Business Teams and deployed the databases on Amazon RDS Cloud to support the critical applications.
• Established mechanisms for database backup/restore of relational databases on Amazon RDS and Physical servers.
• Optimize physical design of MySQL, Postgres, and MSSQL database systems to achieve the optimal performances.
• Setting up the maintenance plans for databases to achieve the highest performance from the OLTP and OLAP environment databases.
• Develop application-specific fault-tolerant distributed database mechanisms.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through security system on both Linux and windows and block/unblock remote access to MySQL server.
• Increased database server performance by utilizing MySQL config changes.
• Design and created different ETL packages using Confidential from Oracle source to SQL server as destination. Created Confidential Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Written various PowerShell and bash scripts for monitoring the database activities
• Developed stored procedures, queries in MySQL for lowering traffic between servers & clients.
• Use to refresh the databases from Prod to QA, DEV and Stage based on the user’s requirements and assign the necessary permissions to the users.
• Successfully resolving MySQL and SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, database corruption, security, and contribute to continuous improvement.
• Involved in setting up the Always on High Availability Database mirroring for MS SQL Server databases.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Supporting management with different database related decisions.
• Handling Release management and user acceptance.
• Create and maintain technical documentation and implement database related policies.
• Prepared the database entity relationship diagrams to show the footprint of database structures.
• Provided 24/7 support in weekdays and weekends.

Confidential, NY

Computer System Analyst (DBA)

Responsibilities:

• Installation of SQL Server 2012/08 on Standalone, Virtual (Hyper-V) and Windows Server Clustered environment.
• Install, configured, and maintained the SQL databases in high availability environment (i.e., Always On).
• Prepared, maintained and modified SQL server installation and configuration documents.
• Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases.
• Perform capacity planning and/or management on system and database resources based on current applications and utilization rate.
• Provide Support to DR setup and testing.
• Experience in setting up the SQL Server Always-on for high availability for Lab systems.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA, and Dev servers.
• Migrated the SQL Server 2008 databases from In house Physical instances to Amazon RDS Cloud Instances.
• Involved in setting up access to the User groups to Amazon RDS after migrating the databases from in house physical servers by following the security policies.
• Created Confidential packages to load robust data from different Heterogeneous data sources like Access, Excel to SQL server.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Used SQL Server profiler to troubleshoot the performance issue or monitoring a server in real time.
• Managed Security using SQL Logins, Roles, and Security Modes for various users.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Prepared the shell scripts and scheduled them using the SQL server agent to throw alerts related to the server performance.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Performed backups and restoration when necessary. Testing the backup and restoration plans.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Involved in implementing the security patches to the database servers to maintain the appropriate security measures.
• Handled numerous change management requests on production servers.
• Provided 24/7 support in weekdays and weekends.

Confidential, IL

Technology Analyst (DBA)

Responsibilities:

• Administered the SQL server 2012 by creating user logins, dropping, and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Installed and Maintained the SQL Servers on Standalone and Virtual Environment Servers.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in developing the Backup and restoration policies for the databases.
• Development of automated daily, weekly, and monthly system maintenance tasks such as database upgrading and indexing updates and apply in development and Testing Environment.
• Involved in SQL server Always-On, Clustering, and Database Mirroring implementation.
• Involved in setting up the Multi-AZ deployments for DB instances running Microsoft SQL Server by using SQL Server Database Mirroring.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas.
• Fine tuned the SQL Server performance by analyzing the databases workload on an Amazon RDS DB Instance with SQL Server Tuning Advisor.
• Deployed and monitored the snapshot and transactional replication on the testing and development servers.
• Refresh the database from production to development and staging environment on daily basis.
• Created permanent tables, temporary tables, and table variables.
• Written Shell scripts to know the status of the sql server services.
• Generated periodic reports based on the statistical analysis of the data from various time line and division using SQL Server Reporting Services (SSRS).
• Using Activity Monitor to identify and resolve Blocking and Deadlock issues.
• Worked on SSRS to generate drill-down, drill-through and ad-hoc reports.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Experience with dropping and recreate the tables for the damaged databases to avoid data loss.
• Conducted design reviews with users/team for development and production strategies.

Environment: MS SQL Server 2008/20012, T-SQL, SQL Profiler, Confidential, XML, MS Office, Windows 2000/2003 and SSRS.

Confidential, NJ

SQL Server DBA\Developer

Responsibilities:

• Migrated Databases, Confidential packages, from MS Access to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Views, Functions, and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas.
• Administered databases in Prod, Qual, Test and Development regions.
• Administered the SQL server 2000/2005/2008/2012 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Monitored, scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2000 and SQL Server 2005 in OLTP Environments.
• Involved in setting up, managing, and maintaining Log shipping and Database Mirroring.
• Development of automated daily, weekly, and monthly system maintenance tasks such as database backup, replication verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Responsible for developing, monitoring, and deploying Confidential packages.
• Loaded data from various sources like excel files, to SQL Server database Using Confidential Package.
• Created permanent tables, temporary tables, and table variables.
• Conducted design reviews with users/team for development and production strategies.
• Working with the Access database users in fixing the issues for day to day operations.
• Prepared the Flow diagrams by using MS Visio to indicate the dataflow between the tables in MS Access and SQL server databases.

Environment: MS SQL Server 2005/2008, Confidential, Active / Passive CLUSTERING, T-SQL, Confidential, XML, MS Office and Crystal Reports 9.0., Windows 95/98, Windows N.T 4.0.

Confidential, St Louis, MO

SQL Server DBA\Developer

Responsibilities:

• Handled up to 2.2 TB Size databases with clustered environment.
• Data Migration from Legacy system to SQL Server 2008 using Confidential packages
• Upgraded/Migrated SQL Server 2005 databases to SQL Server 2008 databases and mentored other technical staff.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored transactional replication on Production, UAT, QA and Dev servers.
• Used SQL Server 2008 Activity Monitor When troubleshooting a performance issue or monitoring a server in real time.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.
• Created SQL Server Audits in developing a risk mitigation plan to keep the environment secure.
• Designed a centralized data repository for storing performance data called management data warehouse and used the fully extensible performance data collection and warehouse tool the ‘data collector’.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Handled numerous change management requests on production and UAT servers
• Maintaining the database consistency with DBCC utility at regular intervals.
• Provided documentation for SQL configuration, and Performance measures.
• Designed Daily, Weekly, and Monthly checklists for the database and server
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved in Source Data Analysis, analysis and designing mappings for data extraction
• Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
• Created and managed financial reports using SSRS
• Evaluated data storage considerations to store databases and transaction logs.
• Review of Technical and Functional High Level Documents (HLDs).
• Developing Test cases for the Interfaces.
• Prepared maintained and modified SQL server installation and configuration documents.
• Installation of SQL Server 2008 on Windows Server Clustered environment.
• Managed and Administrated the SQL Server 2008/2005 production servers.

Environment: SQL Server 2008/2005 (SSMS, SQL Profiler, Index Tuning Wizard, Data Transformation

Confidential

SQL Server DBA\Developer

Responsibilities:

• Installation and Configuring the MS SQL Server 2005.
• Involved in designing the data model for a normalized database.
• Designed database for implementing “Notification Services” in SQL Server 2005.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility.
• Involved in performing Extraction, Transformation and Loading using Confidential .
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Involved in creating normalized Databases, creating objects, sizing temp databases.
• Designing, programming and managing data interfaces, data validation and providing with data modeling.
• Experience in performance tuning, backup and disaster recovery processes and tools.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP.
• Assisting developers with code enhancements, indexing the tables properly.
• Writing the stored procedures, checking the code for efficiency.
• Database monitoring using system tools.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures, and Contingency plans. Testing and implementing these procedures.
• Routine backups and restoration when necessary. Testing the backup and restoration plans.

Environment: MS SQL Server 2000, Windows 95/98, Windows N.T 4.0.