SUMMARY

• To be associated with an organization that gives scope to update my knowledge and managerial skills and be part of a team that dynamically works towards growth of organization and gain satisfaction thereof.
• Over 8+ years of experience in Information Technology as Microsoft Sql Server Database Administrator.
• Have been working as a Production DBA supporting some of the major applications like SDM\Citrix\SharePoint\SAP\Genesis\Sodexo\Avaya\Virtual Edge.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services and T - SQL
• Expertise in Windows Cluster Management with SQL Server Failover Clustering.
• Capacity planning of MSSQL databases and instances for application/product.
• Installation of SQL Server 2005/2008/2012/2014 instances in Clustered environment using Slip Stream and Power Shell.
• Used Autosys in order to configure SQL Jobs.
• Successfully resolved SQL Server problems which involves in-depth knowledge of SQL Server architecture, connectivity, DTS, backup/restore, database corruption, security etc
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Automation of routine tasks by writing T-SQL automation scripts.
• Refreshing, migrating and upgrading databases.
• Fixing Orphan users.
• Experience in setting up, troubleshooting and maintaining SQL Server Databases.
• Experience in implementing High availability technologies like Transactional Log shipping, Mirroring and Replication.
• Experience on Clustering setup and Configuration.
• Experience in database performance tuning DTA.
• Experience on working with SQL Profiler.
• Experience in working on some of the BI tools like SSIS, SSRS and SSAS.
• Well in database developing (designing) and maintaining good client relationships during projects execution.
• Was a part of SOX audit team in order to analyses User Roles and access rights.
• Experience in improving the database performance as well as SQL Query performance.
• Worked on different concepts of ITL framework by adhering to concepts like change order\request\incidents\RTO\RPO and also adhered to SLA’s outlined by company standards.

TECHNICAL SKILLS

Database Versions: SqlServer2000/2005/2008/2008R2/2012/2014&2016

Operating systems: Win NT, XP, Win-7, Win-8, Win 8.1

Servers: Windows 2000, 2003, 2008R2, 2012

Monitoring Tool: Site Scope, SCOM 2007 R2

PROFESSIONAL EXPERIENCE

Confidential, California

SQL DBA

Responsibilities:

• Installed and Configured SQL Server 2016,2014, 2012 on standalone and clustered Environment with Best practices
• Successfully Installed SQL server 2005 on windows 2008 Enterprise Edition advanced servers, applied service packs and security fixes
• Migrating from SQL server 2005 to SQL server 2008 and redirecting users to migrated server.
• Working with system administrator team to virtualize windows and SQL Environment with SQL Server Upgrade to 2012 and/or 2014, Database Migration
• Changes in schema and stored procedures according to changes made in application.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Responsible for Application pools creations according application security and performance needs.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Implemented security policies for SSRS reports.
• Deployed and Debugged SSIS packages using BIDs 2008 R2 and scheduled jobs for these
• Created checklists to install SQL Server installation, service packs, security fix and MS SQL cluster installation.
• Implemented and Scheduled Different Database Backup strategies like Full, Differential and Transactional log backup
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Working experience in a 2-node cluster environment in production where 1 node is active and the other passive.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping.
• Have good experience in installing and configuring SSL certification for security reasons.
• Writing scripts to automate SQL tasks using power shell.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Design and implement Backups and Restore database policies.
• Preparing the golden bits and scripts for smooth deployments to production using applications like Octopus and Sequence manager.
• Install, configure and maintain systems running Windows server 2003/2008 & IIS 6.0/7.0 and participate in server upgrade and planning.
• Good experience in generating reports using SSRS services.
• Involved in deploying and managing websites on IIS servers in both Preview and Production environments.
• Handled huge databases related to some of the major applications like SAP,AVAYA & Share point.
• Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for Database, table size growth.
• Preparing RCA’s/Post-mortem for high Severity tickets/issues.

Confidential, Detroit MI

SQL DBA

Responsibilities:

• Installation and configuration of SQL Server 2012, SQL Server 2000 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Deployed and scheduled SSIS package.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Creation and management of Database maintenance plan for various database consistency checks.
• Good Understanding of ETL (BI) concepts along with strong knowledge of SQL queries.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports.
• Designed and Implemented Reports using Business Objects Full Client.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
• Handled huge databases related to some of the major applications like SAP,AVAYA & Share point.

Environment: SQL Server 2012, 2000, T-SQL, CVS, Windows NT/2000/XP.

Confidential

SQL DBA

Responsibilities:

• Managing 25+ Production, QA, Dev SQL Server from SQL Server 2000, 2005, 2008, 2008R2
• Working closely with third party vendors, reviewing project requirements and supporting SQL Server.
• Database related activity and leading them till project Go Live.
• Designed Document for the change Management process and to set county wise Database Standard.
• Configured and Deployed SSRS reports, Troubles hooted these reports set up subscriptions.
• Prepared plan, Implementation Steps for the Server rebuilt, Server/Database Migration, Server/Database Upgrade.
• Successfully completed SQL Server and Database Upgrade and Migration from one domain to another with proper application testing.
• Successfully done SQL Server, Database, Hardware analysis and Preparing Plan, Implementation steps for SQL Server Virtualization project.
• Designed and Setup SQL Server Clustering, Database Mirroring and Replication as Server and Database level high Availability.
• Designed and created strategy for Index Tuning, Update Statistics, Database Backup and Integrity Check.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server 2000/2005/2008, 2008R2, SSIS and SSRS.

Confidential

SQL DBA

Responsibilities:

• Installing SQL Server 2005 and administration of nearly 50+ servers ensuring zero downtime
• Installed and Configured SQL Server 2005.
• Upgraded the existing database to SQL Server 2005.
• Created Database Snapshots and stored procedures to delta load data from the snapshot database to the report database.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema. Actively
• Actively Involved in data warehousing of the Sybase database onto SQL SERVER 2005.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• 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 owners.
• Developed DTS packages to extract, transform and load into the Campaign, database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Helping application teams in query analysing and its optimization. Coordinating withusers for downtime and maintain the system 24X7 running.

Environment: SQL Server 2000/2005 Microsoft Business Intelligence, Visual Studio for SSIS, SSRS, SSAS, MS Office Access, Windows Server 2003.