SUMMARY

• Around 7 years of professional IT experience in analysis, object oriented design, development and implementation of applications in SQL Database Environment.
• High proficiency with SQL Server Architecture (Fundamentals of SQL Server Architecture, Features of SQL Server, Relational Database Components, Database Architecture, Relational Database Engine Architecture, Administration Architecture, Application Development Architecture.
• Created, Modified, Maintained and optimized SQL server database, Responsible for the management of the database performance, Backup, replication, capacity and security
• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008/2008 R 2/2012/2014.
• Exceptional knowledge of Data partitioning, Data Replication, Data migration and Data modeling, Log Shipping, Database Mirroring and Snapshots.
• Configuring Log Shipping, and supported failover/failback to/from DR environment. Configuring SQL MAIL and Automating SQL MAIL notification.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using Full, Differential, and Log backups.
• Providing Primary DBA (24X7) support to databases in stage and production environment.
• Experience in Creating Roles and Assigning Permissions to the users.
• Experience in Microsoft SQL Server Clustering and in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server.
• Excellent understanding of Normalization /De - normalization, Normal Form and database design methodology.
• Extensive experience with SQL scripts, Stored procedures, Triggers, Functions, Cursors, SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Master in performing administrative tasks: database files management, backup/restore, security management, data integration and synchronization.
• Extensive experience in Server using SQL Server Tools like Database Maintenance Plan Wizard, DTS Import/Export Wizard, Index Tuning Wizard, Replication Sync Manager, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Used Bulk Copy Program (BCP) extensively for flat file import and export operation to/from SQL Server.
• Experience in Tuning SQL queries and T-SQL queries & improving the performance of the Database.
• Worked in various Types of Software Development Life Cycle like Agile, Scrum Methodology.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill. Proactive, independent, self-managing and teamwork spirits and ability to support critical business requirements.

TECHNICAL SKILLS

Operating Systems: Windows, Unix.

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005

ETL and REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, performance counters.

Architecture: Relational DBMS, Client Server Architecture, OLAP,OLTP

Languages: T-SQL, XML, VB.net

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL Server DBA /Developer

Responsibilities:

• Involved in Requirement gathering and Analysis.
• Designed SSIS packages to transfer data between servers, load data into database using SSIS Packages; scheduled the jobs to do these tasks periodically.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats
• Creating Fact Tables, Dimensions for various cubes.
• Created SSIS package with variables and automate SSIS package to handle error with script and send mail task using SSIS 2008.
• Extensively used Joins, Stored Procedures and Sub-Queries to simplify complex queries involving multiple tables.
• Designed and created databases, tables, views, store procedures and triggers.
• Involved in migration of databases to 2012.
• Suggest index tuning and performance optimization techniques.
• Built SSIS packages for processing cubes and dimensions and performed documentation for all kinds of reports, DTS packages and SSIS packages.
• Provided DBA support to Data Warehouse team in their development.
• Designed and deployed reports using SSRS and Microsoft Excel.
• Created pivots to generate daily, weekly and monthly score cards in Microsoft Excel for the executives.
• Responsible for troubleshooting if any problem occurs.
• Excellent written and oral communication skills with a results-oriented attitude. Good in Collecting, Analyzing and Interpreting Data in an organized way. Versatile in working as an individual and also as part of a team.

Environment: MS-SQL Server 2008/2012, SSIS, SSAS, SSRS, SQL-Profiler, IIS, Microsoft Excel, Windows server 2008, MSOffice 2010

Confidential, San Diego, CA

SQL Server DBA/Developer

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005)/(2008), Query Analyzer to Administer SQL Server.
• Migrated SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand alone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Performance log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Experience working with MS SCOM and MS SCCM.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: SQL Server 2005/2008, T-SQL, Excel, Windows 2008 Server

Confidential, Tampa, FL

SQL Server DBA/Developer

Responsibilities:

• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Created and optimized SSIS packages for data flow between SQL Servers.
• Extensively used SSIS and DTS packages for Data Archiving.
• Extensively worked on Extracting, Transforming and Loading(ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Installed, configured and maintained transactional Replication Server.
• Configured Different RAID Levels
• Checking Database Health by using DBCC Commands and DMV.
• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Created Triggers to enforce data and referential integrity.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Performance Tuning, Analysis and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.

Environment: SQL Server 2005/2008, T-SQL, Excel, Windows server 2008 .

Confidential

SQL Server DBA/Developer

Responsibilities:

• Managing of database objects Tables, Views, Indexes
• Installing and configuring of SQL Server 2005/2008.
• Involved in writing scripts for the clients requirements for reporting purposes.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Created cubes and dimensions.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Automatic generation of grouping attribute members.
• Defined Granularity with in a measure group and drill through actions.
• Implemented calculations to aggregate physical measures defined the Browsing Prospective and Browsing Translations and responsible for Process Database Objects Security Role.
• Responsible for writing T-SQL code for creating cursor and handling the data validations and developed complex T-SQL code for the application.
• Transformed the complex business logic and calculations into coding.
• Implementing backups and restoring when necessary
• 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
• Used SQL profiler to monitor the Server performance, debug T-SQL and slow running queries
• Extensively used Joins and Sub Queries to simplify complex queries involving multiple tables.

Environment: SQL Server 2005/2008 Enterprise, SQL Profiler, DTS,T-SQL, BCP, Replication.

Confidential

SQL Server DBA /Developer

Responsibilities:

• Installation and configuration of MS SQL Server 2005/2008.
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using Erwin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2005 for faster execution and developed database structures.

Environment: MS SQL Server 2005/2008, Windows server 2003