SUMMARY:

• Almost 9 years of IT experience on Database Development and Administration with MS SQL Server technology.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) in SQL Server 2005.
• Hands on experience in Transact - SQL (T-SQL), MS Access, vb.net Programming.
• Extensive experience with Backing Up, Restoring and Moving of Databases.
• Configuring SQL Server Agent Jobs. Designing Database Security.
• Hands on experience in Installation and Configuration of SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005 and SQL Server 2000 technology, service packs and hot fixes.
• Experience in SQL database design, architecture, data modeling using Erwin, Data Warehousing and analysis skills, ETL tool with Microsoft Technologies like SSIS/SSRS.
• Strong understanding of RDBMS concepts and Data Modeling Concepts, which includes Logical and Physical Modeling.
• Ability to Implement and Manage Database Mirroring in SQL Server 2005, Always on Availability groups in SQL Server 2008, 2012, 2014
• Ability to create new databases. Capacity Management of SQL Server and Databases.
• Implementing and Managing of Replication in SQL Server 2014, 2012, 2008 and 2005.
• Ability to Migrate Databases from Microsoft Access to SQL Server 2005 and SQL Server 2000 to SQL Server 2005 and to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 and SQL Server 2014.
• Expertise in Database Maintenance by using Managing Index Fragmentation. Managing Statistics, Shrinking Files and Using DBCC Commands.
• Expertise in Failure Diagnosis with Database Failures, Physical Server Failures and SQL Server Service Failures.
• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions, Partitioning and Resolving Blocking and Deadlocking Issues.
• Expert in Disaster recovery Management. Experience in Failover Clustering for SQL Server 2008 Servers.
• Ability to handle the projects as a SME (Subject Matter Expert).
• Good Ability to debug the code issues in Web Applications communicating with SQL Servers.
• Clear understanding of Windows Server Events and SQL Server Events.
• Hands on experience in Deployment of DTS and SSIS packages using ETL Tool.
• Designing SSIS packages for extraction, transformation and loading of data.
• Configuring SSRS. Generating Reports using SSRS.
• Expert knowledge of client connectivity TDS/TCP/IP packages including ODBC, OLEDB, and JDBC.
• Work with developers to move all dynamic SQL into stored procedures and connection strings into web.config files.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/ 2012/ 2008/ 2005 and SQL Server 2000 and Oracle 9i/10g, Microsoft Access 2003 and 2007, MySQL.

SQL Server Tools: SQL Server Management Studio, SQL Server Profiler, DTS, Replication and Mirroring, Always on Availability groups, SQL Server Migration Assistant

Operating Systems: Window 9x, Windows NT, Win 2000, Windows 2003/2008/2012 Server.

Language: C, C++, T-SQL, PL-SQL, C#

Internet Technologies: ASP.NET, HTML, XML, DHTML, VB.NET, JavaScript, Active Server Pages (ASP)

Tools: Redgate, SQL Lite Speed

Ticketing Tool: Remedy 7.6, Jira, Asana

Monitoring Tools: SQL Diagnostic Manager (Idera)

ETL Tool: SQL Server Integration Services

Reporting Tool: SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Developer/Database Administrator

Responsibilities:

• Responsible for designing new schemas, table structures in database.
• Responsible for installation and configuration of SQL Server 2012, SQL Server 2014
• Migrated SQL Server 2008 to SQL Server 2012 and SQL Server 2012 to SQL Server 2014.
• Responsible for creating the database objects like stored procedures, functions, tables and views.
• Analyzing the performance issues in SQL Server and created Clustered and Non-Clustered indexes.
• Created T-SQL scripts to take user defined and system databases backups and stored them in S3 bucket.
• Responsible to set up and support the Always on Availability group on Production databases.
• Identified the unique combination on table’s data and implemented unique non-clustered indexes to avoid inserting duplicates.
• Responsible for troubleshooting the issues in SQL Server.
• Actively participated in Scrums to interact with other developers.
• Provided 24x7 Production support in handling the databases and other applications.
• Handled the databases as a database owner and responsible for assigning the required permissions for the users with in the team.
• Responsible for creating and generating the Tabular Reports, Matrix Reports, Sub Reports, Drill Through Reports using SQL Server Reporting Services.
• Handled couple projects as a SME and delivered them successfully on time.
• Responsible to set up the transactional replication in SQL 2012 and SQL 2014.
• Designed data ware house and scheduled jobs to move data from production databases to data ware house periodically.
• Created T-SQL scripts to monitor dead locks.
• Responsible to create ad-hoc reports using Izenda.
• Queried against mongo database and generated a SSRS report.

Environment: Microsoft SQL Server 2008/ 2012/2014, SSIS, SSRS, Microsoft Office 2007/2010/2013, .Net 3.0, .Net 4.0, .Net 4.5 and .Net 6.0, Windows server 2008/2012, Mongo db, Izenda

Confidential, Concord, CA

SQL Developer/Access developer/SSRS/DBA

Responsibilities:

• Responsible for migrating the databases from Microsoft Access to SQL Server 2005, and SQL Server 2005 to SQL Server 2012.
• Successfully migrated the JDA Application from JDA 2005 to JDA 8.0.0
• Successfully migrated the Oracle 10g database to SQL Server 2012 using SQL Server Migration Assistant
• Responsible for designing new schemas, table structures in new server.
• Maintaining the databases on current system (Microsoft Access).
• Responsible for creating the database objects like stored procedures, functions, tables and views.
• Created front-end design using Microsoft Access for the business users to view the table’s data and reports.
• Created new forms and reports using Microsoft Access to build the front end.
• Analyzing the performance issues in SQL Server and created Clustered and Non-Clustered indexes.
• Identified the unique combination on table’s data and implemented unique non-clustered indexes to avoid inserting duplicates.
• Generated code for the front-end design using visual basic.
• Responsible for troubleshooting the issues in Microsoft Access and in SQL Server.
• Actively participated in Scrums to interact with other teams and developers.
• Provided 24x7 Production support in handling the databases and other applications.
• Analyzing and fixing the performance issues on Oracle 10g databases.
• Good knowledge and experience working on .net applications.
• Responsible for Onshore and Offshore coordination.
• Handled the databases as a database owner and responsible for assigning the required permissions for the users with in the team.
• Responsible for creating and generating the Tabular Reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Handled couple projects as a SME and delivered them successfully on time.
• Responsible for documenting Business requirements, Functional Specifications and Technical Specifications documents.

Environment: Microsoft SQL Server 2000/2005/2008/2012, Microsoft Share Point, Data Stage, SSRS 2005, Micro Strategy, Microsoft Office 2007/2010, .Net 3.0, .Net 4.0, .Net 4.5, Windows server 2003/2008, Site minder, JDA 2005, JDA 8.0.0, Oracle 10g, Power Designer

Confidential, Nashville, TN

SQL Analyst/SSIS

Responsibilities:

• Responsible for migrating the databases from SQL 2005 to SQL 2008
• Used Microsoft Access as a staging environment and then migrated the data to Production SQL Servers.
• Responsible for organizing the data comes in various formats in Microsoft access.
• Used SQL Server 2005 and 2008 to view and manage the data.
• Used Red gate SQL tool belt for any changes in scripts and schemas.
• Responsible for creating the database objects like stored procedures, tables and views.
• Managing SSIS Packages and scheduled them to run in Production servers.
• Responsible for troubleshooting the failed packages.
• Handled the Errors at Control and Data flow level in SSIS Packages.
• Actively participated in Scrums to interact with other teams and developers.
• Generated Master and Validation reports from Microsoft Access and uploaded them to Microsoft Share point Portal.
• Used Internal Utilities to map the data in Microsoft Access databases.
• Used VB.Net to build the macros in Microsoft Access.
• Responsible for solving the performance issues.

Environment: Microsoft SQL Server 2005/2008, Microsoft Share Point, Microsoft Access, Microsoft Office 2007, SSIS, SQL Tool Belt, .net, Windows 2007 and Business objects.

Confidential, Miami, FL

SQL DBA

Responsibilities:

• Administering the MS SQL Server 2005 and MS SQL Server 2008 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Logical and Physical design of SQL Server databases using Erwin.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Supporting Applications with SQL Server 2000 & 2005 & 2008 Databases across Many Locations all over United States.
• Interacted with Application developers and .net developers to trouble shoot the connection issues between applications and SQL Server.
• Worked on Data and Schema Migration from Development to QA and to Production Environment Manually and also using through Automated Tools RedGate for the Schema Management.
• Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent and SMTP.
• Configured and Maintained Database Mirroring as Disaster Recovery solution and worked on day-to-day problems in resolving the issues.
• Worked closely with QA and Business Analysts to produce all required documentation.
• Extensively used Idera Monitoring tool for monitoring the Instances of SQL Server on Test and Production Environment.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Responsible for partitioning very large tables in a database for better performance.
• Created and monitored Database maintenance plans for checking database integrity.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from Database.
• Monitoring the event logs and server error logs for troubleshooting.
• Responsible for handling the project as an SME (Subject Matter Expert).
• Worked closely with the Testing teams for testing the applications from database point of view.
• Connected to Oracle databases using Linked servers to access Oracle databases.
• Handling database objects with SQL Server Management Studio.
• Plan and Schedule the Online/Offline Backups, worked on planning and implemented Disaster Recovery Site.

Environment: Windows Server 2003 Ent / Std, MS SQL Server 2008/2005/2000, SSIS, SSRS, TSQL, Active - Active / Active-Passive Clusters, Veritas Backup Exec Agent, Microsoft MOM Server, SQL Diagnostic Manager, RED Gate SQL Tool Belt, MS Visio 2007, MSOffice 2007.

Confidential, Roanoke Rapids, NC

Database Administrator and ETL Developer

Responsibilities:

• Planned and implemented long-term capacity planning and infrastructure changes to maximize performance for all database components.
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary and creating back up strategies and scheduling them for execution.
• Database design and data modeling using ER Studio.
• Database Inventory, assessment and analysis. Provided 24x7 supports to business operational models.
• Conversed the legacy systems data into MS SQL server using DTS packages
• Resolving various performance issues by using DBCC commands, SQL Profiler and NT monitoring tools.
• Managing databases, tables, indexes, views, stored procedures, enforcing business rules with triggers and user defined functions.
• Responsible for troubleshooting the Web applications to execute the scheduled packages in Production Environment.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Edited and Created new database Maintenance plans and scheduled them on a regular basis.
• Using Linked Servers and Ad Hoc Connections for inserting, updating and deleting data.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Managing security, which includes monitoring and controlling database access, assigning permissions to application users.
• Implemented Snapshot and Transactional Replication.
• Resolved all the issues related to Log Shipping.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.

Environment: SQL Server 2005, SQL Server Integration Services, Windows Server 2003, Peer-Peer Transactional Replication, Business Intelligence Development Studio, SSRS, .NET, Microsoft Exchange Server, AppDetective, SQL Diagnostic Manager, MS Visio 2003.

Confidential, Auburn Hills, MI

SQL Server DBA/ BI Developer

Responsibilities:

• Implementing Query improvements like rewriting the query, schema improvements, statistics management, creating useful indexes and optimization.
• Created new databases and database objects such as tables, views, Stored Procedures, triggers and functions.
• Created backup strategies and written backup scripts by using T-SQL in SQL Server 2005.
• Database design and data modeling using ER Studio.
• Managing security, which includes monitoring and controlling database access, assigning permissions to application users.
• Created different SSIS Packages for importing and exporting data from different data sources.
• Worked closely with programmer in a development group.
• Implemented Database Mirroring and Transactional Replication.
• Analyzed Query Execution plans and created clustered and non-Clustered indexes for better query performance.
• Responsible for writing SQL Scripts.
• Scheduled the different backups by creating jobs and saved them safely for disaster recovery.
• Used BCP to export the xml data between different servers.
• Used Linked server to connect to other OLE DB supported databases like Oracle.
• Used T-SQL code to detect the errors in the data of a database.
• Developed and Implemented new error handling techniques to support Production server.
• Created templates to generate reports according to the user requirements.
• Generated reports using SQL Server Reporting Services.

Environment: SQL Server 2005, SQL Server Integration Services, Windows Server 2003, Transactional Replication, Business Intelligence Development Studio, .NET, Microsoft Exchange Server, AppDetective, SQL Diagnostic Manager, MS Visio 2003.