SUMMARY:

• To pursue a fulfilling career in the area of Service Management as a Database Administrator and Deployment Engineer, broaden the horizons of my skills and understanding and contribute towards the organizational goal.
• Has more than 7 years of experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments as a SQL Server DBA and Developer.
• Confidential Certified Professional with the below certifications Confidential SQL Server 2008, Implementation and Maintenance.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Developing SQL scripts for maintaining administration tasks.
• Managed 17 databases at the headquarters running on 10 servers.
• Have Knowledge of Database backup and disaster recovery procedures.
• Has Knowledge of Replication - Snapshot, Merge and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Access/Excel Sheets to SQL Server 2008.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full - text indexing, and Database Application Development using varied development tools. Extensive use of DTS in SQL Server, Performance Tuning; Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients
• Extensively worked on 32bit, X64 bit and i64 clustered and standalone server environment.
• Expert in extracting and transforming data between homogenous and heterogeneous systems using DTS packages, IMPORT/EXPORT, BULK Insert, BCP and XML Technologies.
• Experience in Database Backup, Recovery, Replication and Disaster Recovery (Log Shipping) procedures.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience of installing, configuring, deploying, Integrating SQL Server Reporting services, Analysis Services on SQL Server.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Experience and Implemented New Features of SQL Server 2008 like Policy management, Resource governor, Data collection, backup compression.
• Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities.

TECHNICAL SKILLS:

RDBMS/DBMS: MS SQL Server 2014,2012,2008,2005, MS-Access

Database Technologies/Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, T-SQL, PL/SQL, DTS, SSIS, OLTP, ADO, SQL OLEDB, DBCC, SSRS, SSAS, Light Speed, Visio 2002,Visual Source safe, TFS, Windows Enterprise Server 2008R2, Windows Enterprise Server 2012

ETL & Reporting: SQL SQL Server Integration Services (SSIS), SQL Server Reporting Services

Operating System: Windows / 2000 / NT / Vista Datacenter and Advanced Server -32bit/64bit. Windows Advanced Server, Windows Exchange Server, Windows NT 4.0/3.5, Windows9.x, Windows XP

Programming Languages: C/C++, HTML, C#, .NET, T-SQL, PL/SQL.

Others: MS Office / / 2014, Outlook etc.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, Washington

SQL DBA

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design.
• Installed Standalone and Clustered SQL Server 2005/2008/2008 R2/2012 instances in Production and preproduction environments.
• Set up database Backup jobs for more efficient recovery by setting up Full/Differential Backup and more frequent Transaction Log Backup for more dynamic databases.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Conduct code walkthroughs and review peer code and documentation.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Created system for capturing, reporting, and correcting error data.
• Worked with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Team player with excellent communication and problem solving skills.
• Strong leader with experience training developers and advising technical groups on ETL best practices.

Environment: SCSM, Visual Studio Team Foundation Server, Windows Server 2008R2, Windows 2012 Server Enterprise Edition, IIS Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, SQL server 2012 Windows Server 2000, Windows Server 2003, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SQL Tuning Advisor, MS Excel, MS Visio, MS SQL Server 2014, 2012, 2008 R2.

Confidential, Fargo, North Dakota

SQL Database Administrator/ Data Architect

Responsibilities:

• Working on the different platforms and making them ready for the deployments.
• Troubleshooting the issues while deploying.
• Deploying on different platforms like Development, SIT/DIT, UAT, Production.
• Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases.
• Migrated SQL Server 2005 databases to SQL Server 2008 R2 databases including DTS to SSIS packages.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment
• 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.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Monitored Log shipping/ Transactional Replication and troubleshooting of errors.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, task assignment and tracking, security breach, etc.
• Rigorous testing on all the Environments before pushing the changes to the Production.
• Validating the changes in the production after deployment.
• Apart from the MBS Products deployment, working on Confidential Dynamics AX which is one of the Confidential ’s ERPs.
• Installing and deploying the Confidential Dynamics and Enterprise Portal UI.
• For every quarter there are releases FQR (February Quarterly Release), MQR (May Quarterly Release), AQR (August Quarterly Release), NQR (November Quarterly Release).
• We use different internal tools like Code puller for pulling of the new code.
• Manual Patching of the Servers.

Environment: ITSM, SQL 2012, Visual Studio Team Foundation Server, Windows 2008 Server Enterprise Edition, Windows 2012 Server Enterprise Edition, Confidential Dynamics AX 2009 R2 and Confidential Dynamics 2012, IIS Server 7.0, SCOM, MS SQL Server 2014, 2012, 2008 R2, SQL Monitoring Tools: Red Gate, SQL Sentry.

Confidential

Sr SQL DBA

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Confidential Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Confidential Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• 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.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: Citrix, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, SQL, Visual Studio Team Foundation Server, Windows 2008 Server Enterprise Edition, Windows 2012 Server Enterprise Edition, Lite Speed, Delphix, MS SQL Server 2014, 2012, 2008 R2.

Confidential

Configuration, Analysis and Testing Engineer (Sr. System Engineer)

Responsibilities:

• Create a change request for any change that needs to be made.
• Analyzes the change raised by the Business owners and Internal Confidential Customers around the world.
• While working on their requests, we use MSSQL 2008 Server Management Studio.
• We create SQL Queries, Stored Procedures and Triggers.
• Our Team looks over 15 Confidential products around the world.
• Working for two teams: automated testing and engineering team.
• Identify various scenarios for functional and integration testing.
• Review the test cases written for integration and functional testing as per the scenarios created.
• Recording the scripts as per the test cases written.
• Deciding the strategy and methodology for manual testing .
• Effort analysis for automated testing and manual testing.
• Effective coordination between development team and testing team.

Environment: ITSM, SQL 2008, Visual Studio Team Foundation Server, Windows 2008 Server Enterprise Edition, Windows 2012 Server Enterprise Edition, IIS Server 7.0, SQL Monitoring Tools: Red Gate, SQL Sentry, MS SQL Server 2014, 2012, 2008 R2.

Confidential

Database Administrator

Responsibilities:

• Works on the tickets created in ITSM Ticketing tool.
• Creates and Assigns tickets to the team as an Incident coordinator.
• Analyzes the issues raised by the customers and Internal Confidential Customers around the world.
• While working on their requests, we use MSSQL 2008 Server Management Studio.
• We create SQL Queries, Stored Procedures and Triggers.
• Our Team supports 40 Applications and Tools, of which I support 10 Applications and 5 Tools.
• I am the server owner for three servers and owner of some Security Groups. Provide access to the users according to their roles.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Implemented database standards and naming convention for the database objects.
• Installation, configuration and upgrading of Confidential SQL Server (SSIS, SSRS) software and related products.
• Developing SQL scripts for maintaining administration tasks
• Evaluate SSIS/SSRS MSSQL features and MSSQL related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• ITIL Skill set requirement (Problem Management/Incident Management/Chain Management etc.)
• Working as DBA for Confidential Project. As a part of Server support, were the point of contact for all the server related issues and resolve the issues based on the SLA and priorities
• Providing quick IT support on around 6-8 servers SQL and IIS.
• Providing quick resolution to Major Incidents affecting more than 10,000 people in Confidential Environment.
• Analyze and Resolve issues with minimal downtime.
• Ensure project delivery as per ITIL standards.
• Provide remote support to requestor located in Redmond, Singapore, Dublin, India and China.
• Was responsible for Knowledge Transition to the new joiners in the project.
• Database tuning and performance monitoring.
• Application tuning and performance monitoring .
• Setup and maintain documentation and standards.
• Work as part of a team and provide 7×24 supports when required.

Environment: ITSM, SQL 2008, Visual Studio Team Foundation Server, Windows 2008 Server Enterprise Edition, Windows 2012 Server Enterprise Edition, SQL Monitoring Tools: Red Gate, SQL Sentry, MS Access, MS SQL Server 2014, 2012, 2008 R2.