SUMMARY

• 9+ years of professional experience working as MS SQL Server Administrator & Developer which includes Database design, development and administration for very large and complex databases involving SQL Server 2008 R2, SQL Server 2008 and SQL Server 2000
• Expertise in Database design, Development and Administration with Server Configuration, Performance Optimization and Tuning with good analyzing and troubleshooting skills
• Strong technical background with the ability to gather requirements, do business analysis and write and follow effective documentation practices
• Expertise in T - SQL, writing Stored Procedures, Functions and Triggers
• Worked on Designing new databases for OLTP, logical and physical database modeling using tools like Power Architect and ERWIN
• Implementing and ensuring industry best practices are followed
• Administering and Designing SQL Server High Availability and Disaster Recovery (DR) strategies
• Expertise in transformation services like DTS, SSIS, BCP
• Implemented new SQL Server features like Service Broker, Data compression, Policy based Management & Resource Governors
• Expertise in troubleshooting and identifying queries that hamper performance using Dynamic Management Views (DMVs) and functions
• Experience driving the technology decision and overall product architecture and giving end to end solution for all database related issues.
• Worked on Server Clustering and Database mirroring solutions
• Expertise in capacity planning, sizing and landscaping the database files and file-groups

TECHNICAL SKILLS

Programming Language: Visual Basic, Java

RDBMS: MS SQL Server 2008, 2005, 2000, Oracle 9i

Operating System: Windows XP, 2003, 2008, 2008 R2

Data Modeling Tools: ER Win, Power Architect

Web Technology / Tools: IIS 7.0

Business Intelligence And Reporting: Cognos8 Report Studio, Crystal Reports 9, Active Reports, Oracle Reports

Domain Expertise: US Life Sciences, Healthcare, Retail

Scripting and other Tools: PowerShell, SQL Stress, SQLIOSim, ProcessExplorer

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead and Database Administrator/ Developer

Technologies Used:MS SQL Server 2008, MS SQL Server 2008 R2, PowerShell, Power, JIRA, Architect, ERWIN, Business Objects

Responsibilities:

• Gather requirements, perform Business Analysis, System and Database Design
• Responsible for overall database design and architecture ensuring optimum level of normalization and standardization of tables for new product development from scratch
• Designed and implemented the Interactive Web Response (IWR) and Interactive Voice Response (IVR) system in clinical trial domain
• Installing and Configuring SQL Server 2008 R2 in all environments, Capacity planning and sizing of the database
• Executing Performance Optimization activities to ensure optimum use of memory, CPU and IO. This involved benchmarking the existing performance and doing index creation, rebuilding, index removal and modifications, updating statistics, changing the file and file group landscape, using Dynamic Management Views (DMV), reading Execution Plans and making appropriate changes to the query and stored procedure. Creating jobs and scheduling them to automate repetitive jobs
• Using Perfmon and SQL Profiler to understand performance bottlenecks
• Implemented new features like Service Broker for auditing and Common Table Expressions(CTE), Error handling through Try-Catch statements, stored procedures were enabled with XML as mechanism to communicate between the Application layer and database layer
• Planning and implementing backup and DR strategy and ensuring database point in time recovery
• Maintain and upgrade the database servers with appropriate Service Packs and hot fix
• Performed regular backup and restore tests to ensure databases can be recovered in case of a disaster.
• Configured Log-shipping to ensuring warm standby
• Configured Transactional Replication mechanism to replicate data from the OLTP to Business Objects Environment
• Configured large tables and indexes to be partitioned for faster archival and enhancing performance
• Managing and maintaining database release schedules and implemented source control using Team Foundation Server (TFS), version management for database releases.
• Created and maintained SSIS packages for data transformation between the OLTP and reporting system
• Installing SQL Server with minimum access control using service account to improve security. Enforced Server and database level security principles to meet regulatory and industry standards
• Deploying new code base release to UAT and production environment for application roll outs
• To analyze long running slow queries and tune the same to optimize application and system performance
• Experience on SAN and RAID levels and building SQL Server cluster server
• Ensuring compliance to 21 CFR Part 11 FDA regulations on clinical trial procedures

Confidential

Team Lead, DBA/ Developer

Technologies Used:MS SQL Server 2008, MS SQL Server 2000, DTS

Responsibilities:

• Write optimized stored procedures and functions to implement business functionality
• Database design, data modeling, normalization and de-normalization of the data
• Designed, maintained, troubleshoot and did enhancements to the DTS packages
• Designed DTS packages to import and load data from various file formats
• Participate in the scheduled release and change management process
• To analyze long running slow queries and tune the same to optimize application and system performance
• Managing data loads into the pre-production and staging databases
• Give technical support and code review activities
• Ensuring all databases are up and running
• Backup and restore activities
• High availability using failover clustering
• Maintain warm standby solution using log shipping
• Do maintenance of existing applications and give application support to the end user, troubleshoot issues with respect to the database performance

Confidential

Senior Software Engineer/ Developer

Technologies Used:MS SQL Server 2000, VB6, Crystal reports 9, Cognos, Oracle 9i, UML, Visio

Responsibilities:

• Requirements gathering, analysis. Create design specifications
• Prototyping and modeling for end client presentation
• Design and development of functional modules using VB6 and MS SQL Server 2000
• Worked on n-tier and Service Oriented Architecture (SOA)
• Write VB6 modules, design forms, Active X Controls for User Interface designing and middle tier business logic layer
• To analyze long running slow queries and tune the same to optimize application and system performance
• Write optimized Stored Procedures, functions and triggers
• Involved in client meeting to understand requirements and meet delivery
• Code review and version control. Adherence to HIPPA and other regulatory requirements
• Creating reports using Crystal reports and Cognos
• Create data models for the reports, publish model into Cognos reporting portal. Scheduling reports to run at various intervals as per business requirements
• Worked on Alpha (Prescription Management Process) in the mail order pharmacies
• Implemented work flow mechanism for paper less process
• Worked on data migration projects using ETL process to load data into the warehouse
• Deploying new code base release to UAT and production environment for application roll outs
• Do maintenance of existing applications and give application support to the end user, troubleshoot issues with respect to the database performance
• Designed and developed VB6 application packages for remote data entry and synch up using FTP

Confidential

Senior Software Engineer/ Developer

Technologies Used:MS SQL Server 2000, VB6, ASP, Crystal reports 9, Oracle 9i, UML, Visio

Responsibilities:

• Requirement study and analysis, discussion with in-house team of domain experts
• Database design and ensure optimum level of normalization and standardization of tables, implementation of functionality through stored procedures and triggers
• Application design, User Interface design, Common library design and DTS package design
• Query optimization and DBA activities
• Discussions, technical support for development and code reviews for team
• Communication and discussion with testing team, and support for volume test and performance test
• Version management, patch management and Source code management with VSS
• Support for resolving the technical and logical bugs, coordination of the team and other departments, support for the team for on-site
• Technical support for the deployment team, Management of Technical Helpdesk
• Database auditing, tuning and discussion with the clients on a regular basis to improve the quality and performance of the software

Confidential

Programmer

Technologies Used:MS SQL Server 2000, VB6, ASP, Crystal reports 9, Oracle 9i, UML, Visio

Responsibilities:

• Requirement study and analysis, discussion with in-house team of domain experts.
• Database design and ensure optimum level of normalization and standardization of tables, implementation of functionality through stored procedures and triggers
• Application design, User Interface design, Common library design and DTS package design
• Query optimization and DBA activities
• Implementation of functionality through stored procedures and triggers
• Application design, User Interface design, Common library design and DTS package design
• Discussions, technical support for development and code reviews for team
• Communication and discussion with testing team, and support for volume test and performance test
• Version management, patch management and Source code management with VSS
• Resolving bugs and tickets raised in the bug management system
• Discussions, technical support for development and participate in code review
• Communication and discussion with testing team, and support for volume test and performance test