Objective:
Seeking a Challenging Lead Position of SQL Server DBA/Architect with the emphasis on the backend design / development in SQL Server 2008/2005/2000 where my other skills in Win 2008/2003/NT, Visual Basic, Visio, Embarcadero, Case Studio, Erwin, consulting and team leadership can be utilized.

SUMMARY:

• 12+ years of experience in software architecture, design and development with primary focus on Database applications and implementation of Business rules using SQL Server.
• Complete software lifecycle experience including Requirement planning, Specifications, Database Design, Development, Testing and Maintainenance as well as implementation.
• Strong Skills in RDBMS Using SQL Server 2008/2005/2000/7.0/6.5, MS Access, Oracle and technologies like Visio, Embarcadero, Erwin, Visual Basic, NT, Win2000/2003 and Data WareHousing technologies.
• Having very good experience with Advanced SQL Server technologies like Replication, SSIS, SSRS, Partitioning, LogShipping, Mirroring and Clustering (Active/Passive & Active/Active) technologies.

Technical Skills Summary:
RDBMS : SQL Server 2008/2005/2000/7.0/6.5, MS Access, Oracle.
GUI Tools : Visual Basic 6.0/5.0.
Languages : C, VBScript, SQL, JavaScript.
Technologies : SQL Replication, Mirroring, DTS/SSIS, SSRS, XML, .NET.
Tools : Visio, Case Studio, Embarcadero CM, Erwin,
Operating Systems : Windows 2008/2003/2000/NT

Experience:

Sr. SQL Server 2008/2005 DBA
Confidential,Alexandria, VA 2006 – current

Projects Implemented:
* GenC – GenerationC (CDHP implementation for Wellpoint BCBS) in SQL 2005 - 2006 – current
* APBM – Anthem PBM (pharmacy Benefit Management) for GenC - 2006 – current
* Member Portal R10 – Anthem member portal re-design in SQL 2008 - 2009 - current

Role & Responsibilities:

• Worked as Lead SQL 2008/2005 DBA.
• Maintained Production & Non-Production db servers for the GenC database.
• Worked closely with the Application\\ Data tier Team for the Logical and Physical Database design.
• Evaluated New technologies and implemented advanced SQL technologies like Mirroring, Replication, Partitioning.
• Performed Installation of SQL Server, Integration & Reporting Services as required.
• Implemented High Availability solution for Production using Clustering technology.
• Worked with the backend team in designing & implementing the SSIS Packages for ETL process.
• Worked closely with the Reporting team for deploying & administering SSRS.
• Implemented more granular security in SQL 2008 /2005.
• Identified performance bottleneck in Production & Resolved as part of Tuning & Optimization.
• provided 24*7 support for the production database maintainance.
• Worked extensively with Visio, Case Studio for designing data flow diagrams and data models.

Environment:
MS SQL Server 2008/2005, VISIO , Case Studio, Embarcadero, .Net SDK, Windows 2008/2003, EMC and Dell/HP servers.

Sr. SQL Server 2005/2000/7.0 DBA
Confidential,Alexandria, VA Sep’2002 – 2006

Description:
Lumenos is a revolutionary new health care company that is paving frontiers in the health care industry with the consumer driven health products like HRA, HSA. They have developed their own application called ‘Lites’ which acts as a bridge between the existing claim processing system and the post transaction updates.

Projects Implemented:
* Lites – Legacy Lumenos HRA Claim Processing system in SQL 2000 - 2002 – 2006
* Hipaa – EDI (electronic) web claim processing system for Legacy Lites - 2003 – 2006
* Empire BCBS – HRA claim processing for Empire Blue Cross Blue Shield - 2004 – current
* HSA – HSA (Health Savings Account) implentation in SQL 2000 - 2003 – 2006
* APBM – Anthem PBM (pharmacy Benefit Management) for Lites - 2006 – current

Role & Responsibilities:

• Worked as Sr. DBA to support on going projects in SQL 2005/2000.
• Maintained Production, Development & QA servers for the Lites database.
• Responsible for Logical and Physical Database design , maintenance, tuning and administration.
• Configured the Replication setup and implemented Transactional Replication in real time scenario in Production environment for Reporting & Web.
• Implemented Database Mirroring in SQL 2005 Servers in production for DR (disaster-recovery).
• Configured and Maintained production databases in Clustered Environment.
• Written several automated scripts for Backup & Recovery, replication and for Notification and implemented them as scheduled jobs in the production environment.
• Written complex SQL statements & adhoc queries that perform data analysis and data migration.
• Managed Login Authentication, User Privileges and object permissions as part of database security and implemented Hipaa & Sox standards.
• Designed & Developed DTS (Data Transformation Services) Packages for transforming and moving of data (data conversion & data load).
• Prepared application Service Packs and Hot fixes.
• Worked on third party products like Lumigent Log Explorer for exploring the transaction log.
• Solved problems related with indexes and slow queries as part of performance tuning.
• provided 24*7 support for the production database maintainance.
• Worked extensively with Visio, Case Studio for designing data flow diagrams and data models.

Environment:
MS SQL Server 2008/2005/2000/7.0, VISIO 2000, Case Studio, Embarcadero, .Net SDK, Windows 2003/2000/NT, SAN/NAS and Dell/Compaq servers.

SQL Server 2000/7.0 Database Administrator
Confidential,Miami, FL Jan’01–Mar’2002
Description:
Financial Technologies Inc., is a financial applications software development company in the venture capital industry. Their leading product name is Investran. It has more than 85 clients such as JP Morgan Partners, Bank of America, SoftBank etc.
Role & Responsibilities:

• Responsible for Logical and Physical Database design , maintenance, tuning and administration.
• Configured Linked Servers between SQL Server 2000 and SQL Server 7.0 servers.
• Managing Login Authentication and User Privileges for more than 100 users.
• Created Transact SQL scripts based on functional requirements as defined by design documents.
• Developed DTS (Data Transformation Services) Packages from design documents.
• Performed data conversions for clients as needed.
• Integrated Investran product with other financial applications.
• Prepared Investran application Service Packs and Hot fixes.
• Solved problems related with indexes and slow queries.
• Managed around 200 databases for development team, QA and Client Team.
• Worked extensively under Citrix Environment to provide 24*7 support.
• Generated conflict reports and Reverse engineered & Reconciled Development and QA databases using Visio 2000, Embacadero ChangeManager.
• Configured Replication setup for the reporting tables for the Investran database.
• Maintained security related activities such as logins and database object permissions.
• Played a key role in the system implementation process such as preparing new databases, including running initialization scripts, configuring maintenance plans etc,.
• Worked closely with client DBA/Project Manager to communicate and coordinate database implementation and maintenance plans.
• Created many automated Jobs including Multi-Server jobs for taking the Backups and Restoring the Databases as per schedule.
• Constructed and Executed Transact SQL scripts & DTS Packages as per the requirements.
• Created several Stored Procedures, Triggers, Applied patches/scripts, as they are received from the development team to the development and Quality Assurance Testing databases.
• Worked within multiple teams (Development team, Quality Assurance Testing Team, Client support Team) simultaneously and Maintained appropriate documentation of all the work performed and script output.
• Provided 24*7 support for the client Team Issues & Extensively Troubleshooted SQL Server day-to-day Activities.

Environment:
MS SQL Server 2000/7.0/6.5, VISIO 2002/2000, DB Artisan, Embarcadero CM, Visual Basic, MS Office, Citrix , Windows 2000/NT and Dell Servers

SQL Lead Consultant
Confidential, Oct ’00 - Dec’00
Confidential,NJ

Role & Responsibilities:

• Worked as a Consultant for the Reporting project .
• Extensive coding in Transact SQL .
• Denormalized the database for the read only data related to analytical purposes to be stored as per the Data wareHousing techniques.
• Written SQL-Server Stored Procs, triggers as per the requirements.
• Written SQL statements that perform data analysis with complex table Joins and calculated fields.

Environment:
MS SQL Server 7.0, MS Office, Visio, Visual Basic, Crystal Reports, MS Access and Windows NT.

Sr. SQL Server Dev/DBA
Confidential,Dubai Jul’98-Dec’99

Role & Responsibilities:

• Involved in system study, design, analysis and development of Web application.
• Analyzing the software requirements in SQL Server 7.0
• Written Triggers and Stored Procedures in SQL Server.
• Used ADO to connect SQL Server and access stored procedures in SQL Server.
• Involved in the User Requirement Study (URS), Testing of modules, User Training etc.
• Migrated MS Access data to MS SQL Server using DTS.
• Establish application security as well as login authentication.

Environment:
SQL Server 7.0/6.5, ASP, VBScript, HTML4.0, JavaScript, Visual Studio, IIS and Windows NT .

Programmer
Confidential,India Dec’97-Jun’98

Environment:
Visual Basic 5.0, Oracle 7.x, MS Access and Windows NT.

Bachelors degree in Science.