SUMMARY

• Over 7 years of experience in the database design,analysis, implementation and support of database management system as a SQL Server developer/DBA.
• Experienced in OLTP/OLAP environment with SQL server 2000/2005/2008.
• Worked on mentoring and setting up high availability environments like active - active, active-passive clustering, database mirroring, Replication, log shipping.
• Setting up servers from scratch on clustered SQL environments and implemented Network load balanced SSRS environment
• Involved in the installation, upgrades and trouble shooting and configuration of MS SQL 2000/2005/2008 database.
• Worked with production and 24 X 7 call environments and documentation of all database architecture according to established standards.
• Working knowledge of the SQL server business intelligence suite (SSIS, SSAS and SSRS).
• Expertise in migration from Sql Server 2000 to SQL Server 2005/2008.
• Knowledge in phases of software development lifecycle (SDLC) involving system analysis, design, development and implementation.
• Proficient in implementing business crucial logic and then in implementing them in back end using efficient stored procedures and functions.
• Implementation of indexes such as clustered index, non-clustered index covering the index appropriately on data structure to achieve faster data retrieval.
• Experience using query governor to monitor long running queries.
• Expertise in the planning and implementation of database security by creating users, roles and assigning permissions to them.
• Implementation of backup, restoration, recovery, replication, linked servers, database maintenance plans.
• Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, Attach/Detach Data Migration tools.
• Experience in creating tables, views, user defined data types and indexes.
• Expertise with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experienced in importing and exporting the data between homogenous and heterogeneous systems using various Extraction Transformation and Loading (ETL) using SSIS.
• Highly motivated and possess ability to think, to analyze and to communicate with users and discuss their data, application and project requirement in a team environment.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2008 R2, 2005,2000, MS Access, Oracle 8i/9i/10g

Programming: T-SQL, PL/SQL, .Net, VB script

Operating System: Windows 2008/2005/2003/2000 Advanced Server, NT, Windows 9x.

Tools: & Software: Performance Monitor, Backup Exec, SQL Lite Speed, Red Gate Tools, SQL Sentry, SSIS, SSAS and SSRS

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. SQL Server DBA

Responsibilities:

• Worked and maintained production databases in SQL 2000/2005/2008 and R2 in a non-stop heavy transactional and reporting environments
• Implemented DR site and high availability servers for production datawarehouse systems.
• Implementation of Transaction Replication with multiple subscriptions from multiple sources.
• Provided 24x7 environment supports for OLTP and Datawarehouse environments for both production and non-production.
• Migrations of database from MS SQL 2000 to MS SQL 2008.
• Implemented Active/Passive and Active/Active clustering based on the project needs with stringent timelines.
• Actively involved as part of team for gathering and analyzing the needs of end user requirement and system specification.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked on complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Created database maintenance plans, regular scheduled DBA tasks for enhancing the performance of SQL Server, some of these tasks included Database integrity checks and re-indexing.
• Created SSIS packages for importing data from various source systems
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Used Erwin to reverse engineer the existing database design in MS SQL Server 2005
• Worked on different kinds of transformations in SSIS as per the client’s Requirement.
• Designed SSIS packages using integration services project in Visual Studio 2008.
• Extensively used various transformations in Control Flow tasks, Data Flow tasks using Visual Studio 2008.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Deployed the databases from old servers to new servers using Replication, based on the business goal.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services (SSAS) and finally to Reporting service.
• Created stored procedures and functions to support complex wealth management logic.
• Modified existing database by adding tables and relationship to existing data model.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created complex stored procedures for about SSIS, which are used in the report to customize the report data and to make data analysis efficient.
• Created various dynamic reports by using formulas in Crystal Report 9 as part of enhancement.
• Moved logic from crystal report into stored procedure to improve performance and keep crystal report as simple as possible by balancing workload between crystal report and SQL Server 2005.
• Worked with SSIS to load text files to SQL Server. Maintained the data, database backups and restoration, backup strategies, scheduled backups.
• Involved in complete backing up of Database and restored the database from Disaster Recovery.
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed using SSIS.
• Involved in testing, bug fixing and documentation for the project.
• Worked on Storage area networks (SAN).
• Well-versed with ITIL processes and implementation for the enterprise.

Environment: Microsoft SQL Server 2000/2005/2008/ R2, SharePoint, SSIS, SSRS, SSAS, Erwin, TFS, Visual Studio.

Confidential, Dallas, TX

SQL Server DBA/Developer

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Deploying new Database objects in production environment.
• Designed new SSIS packages and deployed them.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Migrated data from Oracle to SQL 2005 using Visual studio 2005 package.
• Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Modified Data Flow tasks using Visual Studio 2005
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Writing Stored Procedures, Triggers, and Cursors and creating indexes.
• Fixing Bugs and Automating jobs.
• Testing and loading the data on Development and Production.
• Created DTS Package designs for Import/Export from different servers like oracle to SQL Server.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases Monitor and tune SQL scripts.
• Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created user defined data types and added them to model database for future purpose.
• Worked on Authoring Reports and managing reporting services.
• Logical and physical database design using Erwin Tool.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Performing query plans and making sure each query is using appropriate indexes.
• Provided on - call 24/7 provide support.
• Provided support for in-house and offshore development team.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL, MS PowerPoint, MS Project & Windows 2003 server, Visual Studio 2005, Redgate SQL toolbelt.

Confidential 

T-SQL Developer

Responsibilities:

• Involved in complete SDLC which includes requirement gathering, analysis, design, development, Implementation.
• Involved in capacity planning and sizing for new database servers.
• Migrated MS-access databases to SQL Server 2000 databases.
• Extensively worked on Snapshot Replication.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Used SQL Server System Tables to retrieve metadata.
• Troubleshooted and minimized production down issues.
• Created T-SQL, PL/SQL packages, procedures, functions, triggers, and alerts, scripts for automation and DTS packages for ETL.
• Developed Transact-SQL scripts to enforce business rules.
• Monitoring of alert log files, control files, archive log destinations, blocking, deadlock issues and long running complex queries/stored procs.
• Export and Import of database objects to copy from one database to another database.
• Designed new job process, new database maintenance plans, DTS packages.
• Monitored failed and long running MS SQL Server jobs.
• Resolved blocking and deadlocks issues with the databases / servers on a real-time basis.
• Used SQL Profiler to monitor the server performance, debugging T-SQL and slow running queries.
• Monitored, tuned and analyzed database performance and allocated server resources to achieve optimum database performance.
• Maintained User account administration for Different domains.

Environment: SQL Server 2000, Oracle 8i, C#, MS-Access, SQL, Enterprise Manager, Query Analyzer, Windows 2000, PL/SQL.