SUMMARY

• Over 7+ years of experience in MS SQL Server Database Development and Administration (DBA) in Windows environment.
• Experience in Installation, Configuration and Maintenance of MS SQL Server 2012/2008 R2/2008/2005 versions for standalone, windows clustered environments.
• Experience in Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Extensive experience on Upgrading and Migrating SQL Server Software to new versions and applying service packs and patches.
• Experience in Administration, Database Design, Performance Analysis, and Production Support for Large and Complex Databases.
• Experience in implementing and managing Merge, Transactional and Snapshot Replication models.
• Implementation experience on Log shipping with SQL Server and Database Mirroring with SQL Server and Clustering for high availability and disaster recovery procedures.
• Good knowledge in creating and managing user permissions, logins and setting up security according to business standards.
• Experienced in Creating Databases, Tables, Views, Stored Procedures, Triggers, Functions and Indexes using T - SQL statements based on Functional Requirements considering System and Logical database design.
• Good experience in creating Jobs, SQL mail agent, partitions and scheduling DTS and SSIS, SSRS packages.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, SQL Profiler, Tuning Advisor, SQL Analyzer, Query Analyzer, Replication, SQL Server Business Development Studio (BIDS), SSAS (SQL Server Analysis Services).

Databases: SQL Server 2012/2008R2/2008/2005, Oracle, MS-Access.

Scripting Languages: T-SQL,PL/SQL,ASP.NET, VBScript, Java Script

ETL and Reporting: DTS/SSIS, SSRS.

Operating Systems: Windows 7/Vista/XP/2008/NT/, Unix/Linux

Other Tools: VS, Erwin, IBM Rational Clear Case, MS Word, MS Office, MS Visio, Adobe Acrobat (Reader, Photoshop).

PROFESSIONAL EXPERIENCE:

Confidential - San Francisco, CA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012 on stand-alone and active/passive clusters on Windows Environment.
• Provided support to database Servers. Support included Production, QA and Development.
• Migrated and upgraded several databases to SQL Server 2012 R2 from 2008 R2 on stand-alone and cluster environments.
• Configured and Implemented Log shipping, DB Mirroring and Clustering for high availability of data.
• Created Snapshot and Transactional Replication for SQL Server 2012.
• Worked on designing and implementing the SQL Server behind the Firewall which sits out of domain.
• Designed and Implemented regular backup, maintenance jobs and recovery procedures.
• Managed Security by creating login/groups and assigning appropriate permissions
• Configured linked servers to run distributed queries between SQL Server and other data sources using ODBC, and OLE DB Drivers.
• Worked on deploying and migrating DTS Packages and SSIS packages.
• Developed SSIS packages to transform data between various data sources.
• Created maintenance plans to perform Index De- Fragmentation, Re-Indexing update the Index statistics.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Developed and deployed OLAP cubes, monitoring full and incremental loads using Cube wizard and manual methods.
• Worked in building Multidimensional Expression (MDX) queries and Data Mining Expression (DMX) queries for Analysis Services.
• Developed and configured databases including objects, stored procedures, triggers and cursors.
• Designed and Extracted the DDL changes from the data modeling tools for databases.
• Built and extracted different reports using SSRS.
• Gathered user requirements from users and managers to better understand the business logic and developed required documentation.
• Responsible for database modeling using Erwin tool and diagrams for mapping Entity relations among all the objects.
• Worked as on-call DBA for 24x7 production support along with other team members.

Environment:SQL Server 2012, SQL Server Management Studio, Enterprise Manager, Erwin, Windows Server, SQL Server Business Development Studio (BIDS), DTS/SSIS, SSRS, SSAS, MDX, DMX, SSRS, Windows.

Confidential - Hartford, CT

SQL Server DBA

Responsibilities:

• Working as a Production DBA with 75+ Production MS SQL Servers and 100+ Dev-Test SQL Servers and 1000 + Databases.
• SQL Server 2008 R2/2012 Production Database Administration.
• Installed and configured SQL Server 2012.
• Worked on call support 24/7 and solved many Incident Tickets.
• Hands on experience in Performance issues and troubleshooting database issues.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL Server 2012.
• Created and Maintained jobs, alerts and maintenance plans.
• Worked in Active passive and Active active cluster environment.
• Worked in Huge Transactional, Merge Replication environment.
• Created a new Reporting server in SQL Server 2012 environment which is being tested.
• Installed, authored, and managed reports using SQL Server 2012 Reporting Services (SSRS).
• Maximum performance and uptime in production environment.
• To set up SQL Server configuration settings to resolve various resource allocation and memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created Documentation for steps need to be taken while upgrading the SQL Server 2008 R2 to SQL Server 2012.

Environment: SQL Server 2008 R2/2012, Crystal Reports, SSRS, DTS/ SSIS, Enterprise Manager, SQL Server Business Development Studio (BIDS), Visual Studio, Windows.

Confidential - Richardson, TX

SQL Server Developer

Responsibilities:

• Worked on Migration from SQL Server 2008 R2 to SQL Server 2012.
• Installed SQL Server 2008 R2/2012 on Stand Alone and Clustered Environments on Windows
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups.
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Restricted developer access to production database servers by creating different users and logins on different databases.
• Ensured Security by defining access control to data.
• Re-architected numerous existing databases for increased performance and scalability
• Wrote complex T-SQL Scripts for generating reports.
• Wrote stored procedures and designed triggers.
• Generated reports using SSRS.
• Interacted with development and testing team and Configured Linked Servers.
• Analyzed and Installed Security patches as required.

Environment: SQL Server 2008 R2/2012, SQL Management Studio, T-SQL, Windows Server, DTS/SSIS, SSRS, Windows.

Confidential, TX

SQL Server Developer

Responsibilities:

• Built back-end database using programming and scripting language.
• Experience in improving SQL Server Database performance using Index Tuning Wizard, SQL Profiler and execution plans.
• Installed a SQL Server 2008 on Windows Server.
• Create the disaster recovery plan for production server and development server.
• Support and develop multiple SQL Server Databases and ensure all the developed SQL Server components functions in the production environments.
• Created transactional and snapshot replication on different servers.
• Monitor database environments, related jobs end procedures Database tuning and optimization Write and maintain stored procedures Work with database tools and utilities for administration and development.
• Managing SQL databases, Security, fine tuning of T-SQL queries.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Running DBCC checks and fixing data corruption in application databases.
• Migration of DTS packages to the SSIS on SQL Server 2008.
• Developed complex stored procedures (T-SQL) for front-end application and reports.
• Maintain Fail-Over and Back-up system through use of transaction logs and Snapshot and Transactional Replication.
• Configured and maintained Log Shipping Environments for the projects.
• Capacity planning - properly sizes and organizes including archive logs; calculate optimum disk space, memory, etc.
• Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
• Triggers, jobs and created views and encryption of Stored Procedure on SQL Server 2008.

Environment: MS SQL Server 2008, Windows Server, T-SQL, SQL Management Studio, SQL Profiler, Replication, DTS/SSIS, Windows.

Confidential, Carrollton, TX

SQL Server Developer

Responsibilities:

• Installation and configuration of SQL Server 2005 components.
• Created and maintained Databases, Tables, Views, Stored Procedures, Triggers, Functions and clustered and Non clustered Indexes using T-SQL statements.
• Designing and testing of Backups and Recovery strategies.
• Designed Logical and Physical Data Models using ERWIN and successfully transformed them into Physical Database.
• Troubleshooting, Monitoring and Tuning the MS SQL Server for optimum performance.
• Designing and managing SQL Databases.
• Developing SQL stored procedures views and triggers.
• Involved in performance tuning of the database and T-SQL queries
• Worked on DTS Packages.
• Designing, testing and implementing of DTS packages.
• Responsible to releases from development to test to production environments.

Environment: SQL Server 2005, Windows Server, SQL Management Studio, Enterprise, SQL Profiler, DTS, Windows.