OBJECTIVE:

• A position as a Senior SQL DBA where my significant SQL functional and technical knowledge and team work skills will be of great value to SQL Implementation and support projects.

SUMMARY:

• Over 8 Years of SQL Server DBA/Developer experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2012, 2008, 2008R2, 2005, 2000 in Production 24x7 , Testing, Development, Replication Cluster Server Environments.
• Strong RDBMS concepts and experience in creating and maintaining Stored Procedures , Views, Functions ,Triggers, Indexes, and Constraints.
• Experience in SSIS SSRS SSAS. Wide experience in building static, dynamic and interactive reports using BIDS and Report Builder.
• Experienced in migrating data from one SQL Server version to another.
• An excellent team player technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
• Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in implementing of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Extensive experience in implementing high availability and disaster recovery technologies such log shipping, mirroring, Replication, Always ON and failover clustering.
• Excellent T-SQL Programming skills, Execution Plan, query optimization performance tuning. Used SQL Profiler, Performance Monitor and DBCC Commands.
• Hands on Experience in Writing Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
• Experience in Query Optimization, Re-Indexing, Updating Statistics, tuning Stored Procedures and performing Maintenance Tasks.
• Created maintenance plans to perform index defragmentation, re-indexing and update the index statistics.
• Experience working with DTS Packages, migrating DTS packages.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.
• Experience in Using Performance Monitor/Profiler to resolve Dead Locks/Long Running Queries and to resolve System Hardware bottlenecks.
• Expert in Database migration from MS SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008, and SQL Server 2008 to SQL Server 2012.
• Experience with Reporting Services SSRS and Analysis Services SSAS.
• Worked extensively in OLTP OLAP environments that included Production 24x7 , QA and database development in SQL Server.
• Good operating knowledge in third party tools such TOAD, VERITAS Netbackup, LiteSpeed Pervasive ETL, SQL Assistant, ArcSDE, ERWIN, Visio 2007, Red-Gate and Spotlight.
• Good experience with the entire phases of Software Development Life Cycle SDLC
• Worked closely with development and Technical Support team to resolve quality issues.
• Very good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• 24x7 Production Database on Call Support.

Tools and Technology

• RDBMS: SQL Server 2012/2008/2008R2/2005/2000/7.0, MS-Access 2000/2003/2007, My SQL4/5, Oracle 9i/10g
• Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.
• Languages Tools: VB.NET, Visual Basic, C , PowerShell, C , XML, SQL, T-SQL
• Operating Systems: Windows Server 2012, 2008R2, 2008, 2003, Win ME/NT/XP, UNIX.
• Modeling Tools: MS Visio, Erwin
• Monitoring Tools: SQL Profiler, Task manager, Performance monitoring and activity monitor
• 3rd party Tools: Lite Speed, SQL Safe, RedGate, SQL Secure and Quest spotlight
• Web Servers: IIS 5.0/6.0/7.0, Apache, Tomcat, Amazon web services, Service Center, Virtual Private Cloud VPC .
• Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.
• ETL: SSIS, SSRS, DTS, Informatica, Data Stage.
• Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008/2010, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate, sqlcompare, Dell litespeed

Professional experience

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2012/2008R2 on windows 2012/2008 Servers. Installation of SQL Server Service Packs hot fixes.
• Successfully upgraded the databases from SQL Server 2008 to SQL Server 20012.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Involved in Health Check process for database and monthly auditing of the servers.
• Implemented Policy Based Management, Central management servers, Table and Page level compression and Resource Governor.
• Virtualization of SQL Server in Production environment.
• Created Documentation for steps need to be taken while upgrading the SQL server 2008/2008R2 to SQL server 2012, which includes in-place, side-by-side and standalone migration.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping and AlwaysON
• Worked in Active/Passive and Active/Active cluster environment.
• Setting up daily and weekly backups directly to TSM Tivoli Storage manager .
• Installed SQL Server 2012/2008R2 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Participated in DR installation and troubleshooting Mirroring, Logs hipping and High availability Cluster
• Experience in T-SQL and PL-SQL
• Optimized the Disk space for performance using RAID and SAN.
• Handling the RFC s and work orders assigned to me as part of daily responsibilities.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Documented the security standards and roles depending on Development and Production environments.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements

Environment: SQL Server 2012/2008R2 with Clustering, MS Access, VMware ESX, Windows 2012/2008R2 , Lite speed 5.0 , TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Involved in design and architecture of the entire project flow and integration with third party tools. Interfaced with Business in understanding the present functionality of Planner Reports and defining the phases in which the development would be done.
• Performed daily tasks including backup and restore by using SQL Server 2005/2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Assistance in cleansing data for data consistency whether the data source is a single system or multiple disparate sources.
• Made use of SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Assistance in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery.
• Involved with migration from SQL server 2005 to SQL Server 2008 database.
• Performance tuning using Profiler and Database Tuning Advisor, rebuilding indexes and running Database Consistency Check Commands DBCC .
• Security Implementation, Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Involved in Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication. Implemented replication transactional and snapshot between Main production server and offsite disaster recovery server.
• Assisted in development of extracting, transforming and loading ETL , maintain and support the enterprise data warehouse system and corresponding marts.
• Created sophisticated SQL Server database to responsively handle complex queries triggers, stored procedures, views, functions and .NET data access components.
• Worked on SSRS to generate hierarchical reports and drill down reports and tested using Management Studio in SQL server 2008.
• Worked on SSRS and MS Excel and converted Reports as per Business rules.
• Developed OLAP cubes using SSAS SQL Server Analysis Services and calculate the metrics that were revealed in the functional analysis.

Environment: SQL Server 2005/2008 , VB.NET, SSRS, SSIS, SSAS, Visual SourceSafe,DTS, OLAP, Query Analyzer, DTA, SQL Profiler ,Active Directory and Windows XP platform, DOT NET Frame Work2.0, VB Script.

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Participated in joint application development session JAD to gather information about clients need and to get familiar with vendors product.
• Wrote T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity.
• Developed effective stored procedures, functions to implement business logic.
• Used BCP to move in or out data from different sources.
• Used Bulk Insert to copy large amount of data into database.
• Designing, testing and managing disk tape Backups and Recovery strategies.
• Backing up master system databases and restoring.
• Design and automation of disaster recovery procedures.
• Developed Merchandise Business Analysis report for Top management and Category Buyers using reporting services SSRS and deployed to report server.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration
• Services SSIS .
• Maintained and created Replication: Merge, Transaction and Snapshot and also implemented data transformation to the published articles
• Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SQL Server 2005/2008, VB 6.0, XML,

Confidential

SQL Server DBA/Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Create and maintain the databases using MS SQL Server.
• Installing and Configuring SQL Server on the server and client machines provide connections and manage databases.
• Plan the Backup policy for the databases and Scheduling Online/Offline Backups and performing database recovery using backup sets.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Create packages, procedures, functions, and triggers handle database performance and tuning.
• Apply Service Packs for SQL Server database. Creation of new database, starting from scratch i.e. deciding the location of data files and log files on the disks. Reorganization of existing databases to standardize the placement of various databases related files.
• Creation of additional databases, logins and roles.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Configuring the names pipes for connectivity from client machines.
• Ensuring that the backups are running fine for various databases on different servers.
• Created different objects: Stored Procedures, Triggers, Script to populate data into different tables according to different parameters specified.
• Wrote store procedure to feed different application from SQL Server
• Debugs the Procedures, Triggers, and Views by using Debug tool, monitor the system and SQL server job schedule and record any error logs.
• Migration of Database from SQL Server 2000 to SQL Server 2005.
• Developed various stored procedures used in the application using T-SQL, Created and modified Stored Procedures, Triggers, Cursors
• Used SQL Server Reporting services SSRS for creating, editing and scheduling various reports and scheduled Reports to run on a daily, weekly basis in the Report Manager.

Environment: Microsoft SQL Server 2000/2005, Windows 2000 Server, SSRS, Microsoft Visual Studio

Confidential

MS SQL Server /SSRS/SSIS Developer

Responsibilities:

• Involved in logical physical design, development, and testing of the system.
• Developed complex T-SQL code for the application and implemented constraints on tables.
• Migration of databases from SQL Server 2000 to SQL Server 2005.
• Worked as a developer in creating Stored Procedures, SSIS packages, Triggers, Cursors, Tables, and Views.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created SSIS packages to extract data from heterogeneous into SQL Server 2005.
• Worked on complex data loading implemented the batch data cleansing and data loading .
• Generated reports using MS Reporting services.
• Wrote Parameterized Queries for generating reports using Global variables, Expressions, Data, Defining Data sources and Subtotals for the reports using SSRS.
• Involved in performance tuning using Database Tuning Advisor.

Environment: MS SQL Server 2005/2000, SSIS, SSAS, SSRS, MS Access, Query Analyzer, BCP, SQL Profiler