SUMMARY

• Sr. SQL Server DBA / Developer with 6+ years of extensive experience in IT specializing in SQL Server from installation to end user support including logical data modeling, physical database implementation and data migration of complex logical database designs and relational database concepts in live mission critical Production, pre - production & QA environments.
• Over 6+ Years of experience in Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2012 RC0/Denali CTP3,2008R2,2008, 2005 and 2000. Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data-Stage and ETL package design, and RDBMS source systems like SQL Servers, Oracle, and DB2.
• Involved in creating, Developing and deploying OLAP cubes for reporting purpose using SSAS and created and altered/modified SP’s complex queries, views to generate reports from the cubes and also in data warehouse environments.
• Expertise in SQL server 2012/2008R 2/2008/2005/2000 installation, upgrade, creation and migration of databases, creation of tables, views, migration from SQL and 2008/2008R2 to SQL Server 2012 RC0/2012.
• Responsible for design, setup, installation, and implementation of DB’s, data maintenance (re-indexing, integrity checks, statistics update, log file monitoring), performance tuning (fragmentation, compression drive distribution, load balancing, replication), technical documentation and implementation of SQL Server disaster recovery models .
• Perform security management by maintaining roles, privileges, user profiles, established data security, movement standards for inbound/outbound data movements, working knowledge & experience on writing/editing batch files or shell scripts (.bat & .CMD, power-shell)
• Working with DEV & TEST to drive product fixes & analyzing overall systems workload, performance & functionality.
• Experience in using DMV’s, Performance Monitor, SQL Profiler, Windows Performance Monitor, Database Engine Tuning Advisor, Index Tuning Wizard to solve Dead Locks/Long running queries.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) ( 2005/2008/2008 R2/2012).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.

TECHNICAL SKILLS

Operating Systems: Window 7, Server 2008 R 2/2008/2003.

Virtual Technologies: Hyper-V,VMware vsphere 5.1 and VMware ESXI

Languages: C#.Net, SQL, T-SQL, PL/SQL, Power Shell, Shell scripting

Web Technologies: HTML, DHTML, XML

Databases: SQL server 2012/2012 RC0/2008 R 2/2008/2005/2000, Oracle 11g, MS-Access, DB2

SQL Server Tools/Utilities: SSMS, Enterprise Manager, Query Analyzer, SQL ProfilerDTS, SSIS, SSRS, SSAS

Reporting Tools: SSIS, SSRS, Cosmos, SharePoint Portal and Excel

Monitoring Tools: SCOM, HPOV, IPMON

PROFESSIONAL EXPERIENCE

Confidential, Vacaville, CA

SQL Server DBA

Responsibilities:

• Providing Design, Architecture & Engineering support as well as on-call support for SQL Server databases and servers using SQL Server 2000, 2005, 2008,2008R2 and 2012.
• Performing DB backups, restores, clean-up & DB maintenance activities in a large like fragmentation / re-indexing, log file monitoring, statistics update, integrity checks, performance tuning, disaster recovery & cross group collaboration.
• Implemented numerous components as part of an end-to-end implementation of business intelligence solutions including ETL, design and loading OLAP cubes, MDX and SQL queries reports using SQL Server Reporting Services (SSRS), Share point, performance point and Excel pivot charts.
• Migrating data from DB2 to SQL Server using SSIS and optimize the SSIS packages .
• Plan and design new SQL Server implementations, server-to-server migrations, and upgrades, including database definition, structure, documentation, and long-term hardware and storage requirements.
• Providing standardization and consistency across environments, Design, implement, and monitor database functionality to ensure stable environments.
• Designing storage strategies (ISCSI/SAN/NETAPP) and establish standards for complex database environments, physical structures, and specialized database applications.
• Extensively worked on logical and physical database design, performance, scalability and tuning reviews/assessments (DB and SQL tuning), and query monitoring.
• Installed and monitoring tools like Fog light, SQL Diagnostic manager, SCOM, SQL compare, schema compare, compression tools, etc.
• Regularly monitoring backup & restore jobs, refreshing test databases from production, deploying new applications, datacenter migrations, SSIS package creations, report generations, implemented partitioning logic on heavy tables.\
• Enabled new features like CDC and TDE in SQL Server 2008/2008R2. Migrating data from SQL Server to DB2 using Change Data Capture for Delta updates.
• Advanced level experience with SSIS packages, T-SQL, stored procedures, triggers, cursors, constraints, views .
• Installed and build SQL Server 2008 R2 and 2012 instances and implanted many new features like resource governor, backup compression, server audit, change data capture and central server administration through policy based management and Always ON and Contained databases.

Environment: Win 2008/2008R2, SQL Server 2005/2008/2008 R2/2012, .Net, .Net 4.0, FogLight,DB2 z/OS,TFS,T-SQL,Power shell, SCOM.

Confidential, Redmond, WA

SQL Server DBA

Responsibilities:

• Providing Tier 3 Level of Engineering support as well as on-call support for SQL Server databases and servers using SQL Server 2008, 2008R2 and 2012.
• Designed, Implemented and maintained database schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, constraints, Indexes, Schemas, Functions, Views and complex SQL statements
• Performing DB backups, restores, clean-up & DB maintenance activities in a large like fragmentation / re-indexing, log file monitoring, statistics update, integrity checks, performance tuning, disaster recovery .
• Implemented numerous components as part of an end-to-end implementation of business intelligence solutions including ETL, design and loading OLAP cubes, MDX and SQL queries reports using SQL Server Reporting Services(SSRS), Share point, performance point and Excel pivot charts.
• Plan and design new SQL Server implementations, server-to-server migrations, and upgrades, including database definition, structure, documentation, and long-term hardware and storage requirements.
• Providing standardization and consistency across environments, Design, implement, and monitor database functionality to ensure stable environments.
• Performed Query Optimization for long running queries, SP’s, logical and physical database design, performance, scalability and tuning reviews/assessments (DB and SQL tuning) and changing Configurations in SSIS according to the environment.
• Expert to use DMV’s, SQL Profiler, Index tuning wizard for of current SQL server performance issue.
• Installed and monitoring tools like Ignite, SQL Diagnostic manager, SCOM, SQL compare, schema compare, compression tools, etc.
• Setting up Listener creation on production/Pre-Production stand alone SQL servers and Availability group creations in SQL Server 2012 .
• Good knowledge in Migration from SQL Server 2008/2008R2 to SQL Server Denali CTP3 and SQL Server 2012 versions.
• Regularly monitoring backup & restore jobs, refreshing test databases from production and transfer data from one Server to another using SSIS package maintenance plans.
• Installed and build SQL Server Denali instances and implanted many new features like Always on High Availability, Columnar store index, T-SQL Enhancements, User-defined server roles, Data Quality Services, Contained Databases, SQL Server Developer Tools and Change data capture .
• Developed Query for generating drill down, sub reports in SSRS 2008R2. Prepared Ad HOC reports through report builders.
• Good understanding ofMicrosoft ReportingService(SSRS)with Report authoring, Report management, Report delivery andReport security and Report Configuration.
• Experience in developingCustom Reportand different types of Tabular Reports, Matrix Reports, Ad hoc reports in multiple formats usingSQLServerReporting Services(SSRS) in Business intelligence development studio (BIDS).
• Supported cloud applications using windows Azure and SQL Azure and worked in Geo Redundancy data centers.

Environment: Win 2008/2008R2/2003, SQL Server 2008/2008 R2/2012, .Net, Windows Azure, SQL Azure 3.5, .Net 4.0, IIS 7.0, Power shell, SCOM.

Confidential, Minneapolis,MN

SQL Server Administrator

Responsibilities:

• Provide software build support & ongoing assistance with build activities to ensure timely delivery of testing, Pre-production and production software builds in a highly software development life cycle process & creation of cross-functional flow charts as part of Reverse Engineering.
• Created new tables, Views, Stored Procedures, Triggers, Functions and Indexes to meet functionality.
• Installed SQL Servers 2005/2008/2008 R2 all Service packs and hot fixes and critical patching on many production Active- Active & Active-Passive cluster boxes and stand alone cluster instances.
• Set up Log shipping and replication in several servers to maintain disaster recovery for SQL Server.
• Migration of several Production and non-production SQL server and .
• Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc…), database capacity issues, replication, and performance tuned the stored procedures for optimal efficiency using execution plans, profiler traces and database engine tuning advisor.
• Performed Capacity planning, audit, Performance of characteristics of production servers in current environment and estimate for future usage.
• Successfully build the new data center, migrated the data from the old data center to new data center and brought the project from development phase to go live phase on a Geo redundancy environment.
• Configured SMTP Server for sending automatic mails to the respective people when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit.
• Backup automation is implemented on all production servers, which includes full, differential & log backup using recovery models and scheduled to run at regular intervals everyday.
• Migrated data from different sources ( text based files, Excel spreadsheets, and Access ) to SQL Server databases using SQL Server Integration Services (SSIS).
• Responsible for Full report cycle including authoring, Managing, Security and generation of reports.
• Created Summary reports, sub reports, drill down reports, Matrix reports, ad-hoc reports using SQL Server 2008 Reporting Services (SSRS).
• Expert to use monitoring tools SQL compare, Red gate, SQL Profiler, DMV’s and third part tools is idera, SQL diagnostic manager.
• Used Information Schema views, SYSTEM, Triggers, SYS.dependencies for various database application needs to verify the common columns/Key columns list between the tables, finding the triggers list on a table and finding the dependencies on abject.

Environment: Win 2003/ 2008, SQL Server 2005/2008/2008 R2, Net 3.0/3.5, IIS 6.0, Power Shell

Confidential, Minneapolis, MN

SQL Server DBA / Developer

Responsibilities:

• Created Documentation, schema designing, ER Diagrams using Erwin, MS Visio and involved in architecture and Monitoring, optimizing the performance of the database servers.
• Provided recommendations for improvements on existing topology, documentation for overall database performance and estimations for future expansion of databases.
• Installation of SQL Server 2000/05 and on Windows Server Clustered environment.
• Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration and migrated SQL Server 2005 to VMware and Oracle to SQL.
• Data transferred using BCP/Bulk insert from Excel, Flat files to SQL Server vice-versa with different formats.
• Used DMVs, DMFs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes for query/SP’s tuning.
• Troubleshoot Application connectivity issues, Blocking and deadlocking issues.
• Responsible for monitoring Jobs, SQL auditing, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved file group modifications, and scheduling jobs to rebuild/reorg indexes, update statistics and security.
• Created stored procedures/Packages DB-links, triggers using T-SQL and PL/SQL programming according to the business logic.
• Performed backup and recovery functions by RMAN and logical backups by Export, Import and Data pump utilities for Oracle databases and Lite-speed backup for SQL Server databases on Clustered environment.
• Resolved database space issues by sizing Table spaces, data files, and log files in Oracle.
• Used third party tool Lite speed for database backups and restorations.

Environment: SQL Server 2000/2005, Advanced Windows Server 2005/03, T-SQL, PL/SQL, RMAN, SSIS, SSRS, SSAS, Lite-speed.

Confidential

SQL Server Developer

Responsibilities:

• Created new database objects like Tables, Views, Triggers, Stored procedures, Packages, Functions in SQL Server 2000/2005.
• Setting up new MS SQL Server instances and databases.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Managing logins, roles, assigning rights and permissions. Created Views, Schemas to implement security.
• Created SSIS packages, BCP for data transfer from one server to another server and data imported from Flat files to SQL server tables and EXCEL to SQL server tables.
• Drive documentation for processes and improvements to streamline and optimize work performed.
• Setup mirroring and replication in Pre-production environments.
• Worked on client/Server tools like SQL Server Enterprise manager and Query Analyzer and Execution plans to administer SQL Server.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler and Index tuning wizard.

Environment: SQL Server 2000/2005, Visual Basic 5.0, Windows NT, T- SQL, MS EXCEL,MS Access.