SUMMARY

• Having 11 plus years of experience in the Information Technology Industry including solid 7plus years of experience as a SQL Server DBA and related Technologies. Worked as senior SharePoint 2010 Server Administrator and .NET Developer on Client Server and web based environments.
• Hands on Experience in Installation, Query Optimization, Performance Tuning, Security Administration, Capacity Planning, Trouble Shooting and DBCC utilities.
• Experienced in perform Bench Mark testing on EMC SAN.
• Experienced in installing and Managing SQL Server environment on Active/Active, Active/Passive clustering on Physical and Virtual Windows Server 2008 R2 Environment.
• Experienced in High Availabulity Solutions like LogShipping, Database Mirroring.
• Experienced in Transactional Replication with updatable transactions on SQL Server 2005 Environment.
• Experience in upgrading SQL Server from 2000 to 2005 / 2008.
• Experienced in Data Modeling, Reverse and Forward Engineering using ERWIN.
• Hands on Experience in develop Database Backup Stratagies, Database Recovery plansand impliment in entire life cycle.
• Profecient in design, develop and implement SQL Server Automation process using SQL Srever Agent and convert DTS packages to SSIS using DTSXchange Tool.
• Experience in Data Center Migration and Consolidation Projects.
• Experience in conducting meetings with clients when upgrading older version SQL Server to newer version.
• Experience in manage SQL Server environment to follw SOX, NIST guideline.
• Experience in Linked Servers, Database Snapshots, DDL triggers, PBM, TDE and Database Auditing
• Installing and Configuring MOSS 2007 and SharePoint 2010 Visual Studio 2008 enterprise editions through out the system life cycle.
• Experience in installing and configuring CA ArcServe r16SP1/r16SP2/r16.5 version for SQL Server HA and DR solutions including transfer SQL backup file to offsite replication for costeffective solutions
• Expericence in developing Automated T - SQL Scripts and SSIS packages.
• Having different industrial experience like Insurance, Telecom, Pharmaceutical andFederal government sectors

TECHNICAL SKILLS:

• SQL Server 2012 / 2008 R 2 /2008 /2005 / 2000 , 7 + Years of experience
• SQL Server 2008/2008R2 New Features (PBM, Auditing, TDE Ext.), 4 + Years of experience
• T-SQL, PL/SQL, DTS, SSIS, SSRS*, 7+ Years of experience
• Stored Procedures, Functions, Views and Database Triggers, 8 + Years of experience
• Windows Server 2000/2003/208 and 2008 R2, 10+ Years of experience
• Oracle 8i/9i/10G, 2+ Years of experience
• PRECISE I3 for SQL Server, Quest SoptLight, LightSpeed, Change Director, Tode, SQL Safe 6.5, SQL Developer, IDERA DM, RedGate Tool Belt, ERWIN, 3+ Years of experience
• MS-Office, Visio, 10+ Years of experience
• PowerShell, DOS Scripting, 4+ Years of experience
• SQLIO, Quest BenchMark Test, 2 + Years of experience
• MOSS-2007, SharePoint 2010, 1 + Years of experience
• C++, Visual Studio 2005/2008/2010 , 2 + Years of experience

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. SQL Server DBA

Responsibilities:

• Involved in Capacity Planning (SAN) and provided disk space requirements by analyzing database sizes and recommended separate drives for Data, Logs, Backups and TempDB
• Performed Bench Mark Testing on EMC SAN using SQLIO and SQL Server Bench mark testing using Quest Bench Mark test Tool
• Reviewed server configuration and worked with SAN and Capacity Planning teams to effectively communicate requirements for VLDB
• Installed and Configured SQL Server 2012 in Dev, Val, Integration, Pre-Production& Production environments for new company-wide Confidential database systems
• Installed and configured SQL Server Clustering Active/Active on 2 Node Windows Server 2008 R2Physical R900 Servers cluster for production, VMware ESX environment for Pre-Production to maintain High availability.
• Performed Reverse Engineering and Forward Engineering on in-house Database using ERWIN Data Modeler in order to upgrade from SQL Server 2005 to 2008. (Not fully functional Erwin is working on that)
• Implemented Policy Based Management System (PBM) on entire life cycle in-order to evaluate NIST (National Institute of Standards and Technology) security standards.
• Implemented TDE(Transparent Data Encryption) on Confidential wide databases to provide comprehensive security and protection on customer’s PII information
• Implemented Security Administration by adhering to security protocols/standards/policies and provided minimum permissions in Production by using Integrated Authentication.
• Resolved Performance issues in Production systems related to Cursors, Indexes, Full Text Search, Blocking, Deadlocks, Query and Stored Procedures optimization and Fragmentation.
• Implemented Customized Log Shipping for a mission critical database using custom scripts and FTP as the transaction log files were very large
• Created Custom Database Roles and tracked all Production changes with Change Requests and efficiently handled Incident Management
• Developed several automated administrative scripts (T-SQL, Batch) for easy deployment and database release process through entire SDLC from Development to Production
• Developed automatic script generator for create table level trigger for Last Update time stamp column on every database table.
• Conducted meetings with customers to explain about the business process and benefits of SQL Server new features before upgrading their SQL server 2005 environment to SQL Server 2008 R2
• Converted and standardized all Database Maintenance Jobs and Maintenance Plans including Backups, Rebuilding and Reorganizing Indexes and Updating Statistics
• Used SQL Compare and Data Compare software to insure Production and Development environments were kept in sync with Confidential environments
• Documented Database Strategies, Architectures, Security Policies, SQL Server Installation and Configuration, daily SSIS processing flows, Replication procedures, SQL Standards, SQL Inventory, Licensing details, Monitoring and Security Standards

Environment: Windows Server 2008R2 x64 bit/2008 x64 bit, MS SQL Server 2012/2008R2/2008/2005, Erwin, EMC SAN, RedGate SQL Compare 8.0& Tool belt, Terminal Services, Quest Tools, SQLIO, Microsoft Visual SourceSafe, Microsoft Visio, Windows Power Shell 1.0, SSIS, Visual Studio 2010

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Installed & configured SQL Server 2012 Standard editions and participated in upgrading versions from SQL Server 2008 R2.
• Responsible for data availability, integrity, consistency, and performance of 2,000 critical databases.
• Worked with Independent Software Vendors (ISVs) to identify desired 3rd party tools based on customer needs.
• Tune Transact-SQL code, SQL Server configurations, and operating systems for optimal performance.
• Design, develop fully automation and standardization of SQL Server environment to operationalize repetitive tasks.
• Architect database systems for disaster recovery and high availability including custom Transaction Log Shipping using Native method, 3rd party tools.
• Architect restored environments from production backups and synchronized VLDBs with customized SQL solutions on a daily basis.
• Designed the backup and recovery strategies for SQL Server databases to meet customer SLA requirements using native, RedGate 7.3 and Idera SQLsafe tools.
• Installed & configured CA ARCServe HA & Replication solutions to provide customers High Availability and DR solutions on their SQL Servers with less cost & more efficient solutions.
• Implement change management controls, processes and practices to deliver quality services that increase client bottom line results.
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
• Developed and optimized stored procedures, triggers, and SSIS packages.
• Developed and created stored procedures, advanced queries, triggers for databases
• Developed a custom automated program to perform database backups with SQL Server express edition using Windows Task Scheduler.
• Successfully engaged in various DR (Disaster Recovery) efforts for many customers.
• Made recommendation on systems hardware and software implementation for management approval and took responsibility for complete and timely implementation.
• Organized and coordinated daily operations and project delivery meetings to identify all possible problems and ensure they are rectified to keep project on schedule and report any project variance to the appropriate upper management personnel.
• Developed a custom report to monitor all SQL Server instances scheduled jobs, disk space monitoring
• Managed the entire database environment visibility and accountable for every database decision made to upper level management.
• Provided 24/7 Production Support (on-call) and resolved all tickets opened by Production Team including SSIS/SQL Job failures, Disk space issues

Environment: SQL Server 2012, SQL Server 2008 R2, Windows Server 2008 R2, IDERA SQLsafe Backup utility Tool, RedGate SQLBackup, EMC SAN, Terminal Services, CA ARCServe R16.5, SSIS, SSRS

Confidential, Beltsville, MD

SQL Server DBA

Responsibilities:

• Involved in architecture and technical design phase of different projects to provide an efficient and robust SharePoint based solution
• Involved in Capacity Planning (SAN) and provided disk space requirements by analyzing database sizes and recommended separate drives for Data, Logs, Backups and TempDB
• Installed & Configured SQL Server 2008 R2 Enterprise and SharePoint 2010 Enterprise on Dev, Val, Integration, Pre-Production and Production environments.
• Reviewed server configuration and worked with SAN and Capacity Planning teams to effectively communicate requirements for VLDB
• Implemented Security Administration by adhering to security protocols/standards/policies and provided minimum permissions in Production by using Integrated Authentication.
• Resolved Performance issues in Production systems related to Cursors, Indexes, Full Text Search, Blocking, Deadlocks, Query and Stored Procedures optimization and Fragmentation.
• Implemented Customized Log Shipping for a mission critical database and FTP as the transaction log files were very large
• Created Custom Database Roles and tracked all Production changes with Change Requests and efficiently handled Incident Management
• Developed several automated administrative scripts (T-SQL, Batch) for easy deployment and database release process through entire SDLC from Development to Production
• Converted and standardized all Database Maintenance Jobs and Maintenance Plans including Backups, Rebuilding and Reorganizing Indexes and Updating Statistics
• Coordinated and implemented roll out of Service Packs/Hot fixes/Patches to bring all SQL Servers to a uniform and latest service pack level on entire lifecycle
• Provided 24/7 Production Support (on-call) and resolved all tickets opened by Production Team including SSIS/SQL Job failures, Disk space issues, Log shipping and Mirroring issues.

Environment: SQL Server 2008 R2, Windows Server 2008 R2, IDERA SQLsafe Backup utility Tool, EMC SAN, Terminal Services, MS Office SharePoint Server 2010, SharePoint Designer 2010, InfoPath 2010, Visual Studio.Net 2010, CSS, JavaScript, XML Technologies, SQL Server 2005, IIS 6.0, Active Directory Services, Project Server 2007.

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Installed & configured the SQL Server 2005 database with latest SP, Surface Area, Service Account, required instances and client tools for all environments.
• Extensively involved in installing & configuring the SQL Server 2005 in Clusters in different environments
• Created & Managed the required databases in all environments
• Configure the security by creating logins and mapping users to logins, Server Roles, Database Roles, Application user defined roles and Linked Servers as per solution approach document
• “Disaster Recovery (Point-In-Time)” Developed new Backup and Restore policy for the entire environment by using Mirroring and Log Shipping
• Created and configured the Database Maintenance Plans to perform the day-to-day upkeep on all the databases.
• Participated extensively in the architecture and technical design phase of different projects to provide an efficient and robust SharePoint based solution.
• Designed and developed Master and Content Pages with look and feel for branding using SharePoint Designer and developed custom ASP.Net pages using Visual Studio 2008 environment.
• Created Dashboards using Data View Web parts by connecting to different application servers using BDC to pull the information/data and also worked on connecting data view web parts for different project profile pages by passing parameters using Project Server data
• Designed, developed and published the web based InfoPath Form Templates for various business needs and created automated approval / feedback / notification / task creation process using Nintex workflows.
• Created custom web services for backend databases to pull and push data from DVWP & InfoPath.
• Created sub sites for each department within the organization and automated the business process using workflows and InfoPath Forms.
• Configured Incoming e-mail configuration on Document Library for uses can post project comments directly from their outlook e-mail.
• Integrated the Project Server with SharePoint to import the tasks list and convert to a Proposals and Operations project for management by PWA with simple timesheets, and task and resource management
• Involved in performance analysis of page loading of Dashboards and given best fits for the applications.
• Created and written technical documentation - Functional Specification, Technical design Specification, Use Cases, Test Cases, Cross Functional Charts, and Business Process Workflow Diagrams for the applications designed in SharePoint and conducted demos and presentations for usability.

Environment: MS Office SharePoint Server 2007, Windows SharePoint Services 3.0, SharePoint Designer 2007, InfoPath 2007, Visual Studio.Net 2008, .NET framework 3.0, C#, ASP.Net, CSS, Java Script, XML Technologies, SQL Server 2005, IIS 6.0, Active Directory Services, Project Server 2007, Nintex Work Flow and Zone Tab (Third Part Web Part Tool).

Confidential, Alpharetta, GA

SQL Server DBA

Responsibilities:

• The project was one of the best example for implementation of several administrative tasks including Clustering, Linked Server, Log shipping, Replication, Snapshot and Mirroring.
• Involved in modeling physical and logical database structures using Microsoft Visio, Erwin for designing ERD and DFD and implemented SQL Server 2005 on Windows Server 2003
• Involved in Provisioning drive space (SAN, SCSI, other) and Virtualization configuration meetings with core team.
• Installed & configured the SQL Server 2005 database with latest SP, Surface Area, Service Account, required instances and client tools for all environments.
• Extensively involved in installing & configuring the SQL Server 2005 in Clusters in different environments
• Created & Managed the required databases in all environments
• Configure the security by creating logins and mapping users to logins, Server Roles, Database Roles, Application user defined roles and Linked Servers as per solution approach document
• “Disaster Recovery (Point-In-Time)” Developed new Backup and Restore policy for the entire environment by using Mirroring and Log Shipping
• Created and configured the Database Maintenance Plans to perform the day-to-day upkeep on all the databases.
• Extensively used Importing & Exporting Data (ETL) using BCP& BULK INSERT, DTS Packages and SSIS utilities
• Worked on High Availability solution process by configuring the Replication, Database Snapshots and Log Shipping on multiple environments
• Worked on Common DBA Tasks not limited to Troubleshoot Blocking, Deadlocking (using Profiler), Re-Indexing and Performance Tuning
• Involved in Database Upgrade from SQL Server 2000 to 2005
• Attended the Corporate Training Sessions on migrate all DTS packages to SSIS using the tool DTS XChange
• Global documentation for SQL Server standards, Disaster Recovery, Monitoring and Installation Process as per the AT&T Express One policies
• Attend the Audit meeting with SOX Team to discuss about current Security Issues on SQL Server.
• Standard and advance Database Maintenance tasks as Installation, Setup and Configuration, DTS & SSIS, DB Tuning, Maintenance and Troubleshooting, Disk / Space(with SAN&RAID), Capacity planning, DB Optimization, Index Management, Security, Database Backup & Restore and Production Support 24 x 7

Environment: MS SQL 2000/2005, T-SQL, Windows 2000/2003, Erwin, Password Safe, DTS XChange, MS-Access, Redgate SQL Compare 6.2, Terminal Services, IP Monitor

Confidential, Iowa City, IA

SQL Server DBA / SharePoint Developer

Responsibilities:

• Involved in Database Upgrade from SQL Server 2000 to 2005
• Standard and advance Database Maintenance tasks like Installation, Setup and Configuration, DTS, Management, DB Tuning, Maintenance and Troubleshooting, Capacity planning, DB Optimization and Index Management, Security Maintenance Database Backup & Restore and Production Support, 24 x 7
• Responsible for Performance Monitoring, Trouble-Shooting, and Load Balancing of SQL Server Database.
• Responsible for Security Administration- creating users and assigning them roles and privileges
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups
• Backing up system & user databases and restoring them when necessary Installation of SQL Server Service Packs
• Involved in building the servers on the Cluster environment
• Installed SQL Clustering for 2 Production QA environments and Maintained SQL Servers with High availability.
• Experience with Replication and Log Shipping
• Involved in Installed, configured and maintained SQL Server Fail over clustering for 3 production environments
• Installed SQL Server 2000 on Windows 2003 servers and Applied Service packs and security fixes
• Configured Log shipping for 2 environments to create a Disaster Recovery Stand by servers
• Responsible for Stored procedure optimization, Performance tuning and DTS
• Involved in tuning the database and server performance and worked with Profiler to trace and tune the database.
• Involved in complete Life Cycle including analysis, design, development and testing
• Involved in installing and configuring of MS Windows Share Point Services 3.0/2.0 & Share Point Server 2007
• Participated in Migration of the project from SPS 2003 to MOSS 2007
• Created Custom Site Templates and Layout Pages to create Sites
• Worked with Windows SharePoint Services and Team Site, Document libraries & lists
• Developed custom security provider which interacts with MOSS 2007 (lists, permissions, user groups and copy), and the existing single sign-on application and this is responsible for managing the Lists, Document Libraries, documents and security at document level, document library level and site level
• Worked on Business Data Catalog (BDC) to integrate business data from back-end server application to Office Share Point Server 2007

Environment: MS SQL Server 2000/2005, Windows 2000/2003 Server, Enterprise Manager, Query Analyzer, T-SQL, Quality Center 8.0, SQL Compare 5.0 Visual Studio .Net 2005, C#, SPS 2003, MOSS 2007, Windows Share Point Services 3.0/2.0, ASP.NET, XML, and Web services, Windows XP-Professional, Windows Server 2003, and SQL Server 2005

Confidential, Cedar Rapids, IA

Senior .NET & SharePoint Developer

Responsibilities:

• Worked with Windows SharePoint Services and Team Site, Document libraries & lists
• Developed custom security provider, which interacts with MOSS 2007 (lists, permissions, user groups and copy), and the existing single sign-on application. This is responsible for managing the Lists, Document Libraries, documents and security at document level, document library level and site level
• Developed workflows using InfoPath Forms, and also implemented the out of box workflows and web parts using SharePoint server 2007
• Improved the look and feel of the Sites using & creating Cascading Style Sheets
• Created and deployed new SharePoint web parts using Visual Studio .Net 2005 and implemented web part connections
• Interact with client and gather User Requirements
• Design and develop the GUI, Business Logic Layer and Data Access Layer
• Developed the Web forms for new policy endorsement, policy cancellation, renewal, reinstatement, account correction, audit, premium calculation, coverage, policy information, billing details, policy inquiry, and work file information using ASP.NET, C#.NET,XML, Java script
• Designed database in SQL including relations, tables and views
• Implement Role Based security with Form Based Authentication
• Written complex SQL queries with Joins on multiple tables, Stored Procedures, Triggers, Backup and Restore Database, Define roles and Create database users
• Application design based on n-tier Architecture
• Designed Logical and Physical Data Model
• Involved in unit testing, fixing bugs and maintenance of the product

Environment: C#, ASP.NET, SQL Server 2005, ADO.NET, Web Services, Visual Studio 2003, XML,HTML, DHTML, JavaScript, MS Visio, NUnit, C#, SPS 2003, Windows Share Point Services 2.0, ASP.NET, XML, and Web services, Windows XP-Professional, Windows Server 2003