SUMMARY

• Permanent Resident (Green Card) with over 7 years of IT experience of which 6 years in Design, Development, Administration, Support & Maintenance of SQL Server Databases in complex heterogeneous SAN replicated environments.
• Extensive experience in Installation, Configuration, Upgrading, Maintaining and Merging of SQL Server databases in OLTP & OLAP environments in Banking, Insurance & Health care sectors.
• Basic experience in managing & maintaining Oracle databases in both Windows & UNIX environments.
• Experience in advanced SQL Server 2008/2008 R2 features and functionalities like TDE, Compression, Resource Governor, Data Collection and Policy Based Management and good exposure in SQL Server 2012.
• Extensive experience and knowledge in T - SQL - DML, DDL, Transactions, Stored Procedures, Triggers and Functions
• Experience in SQL Server Performance Tuning using tools like System Monitor, SQL Server Profiler, Optimized expensive running Queries using Database Engine Tuning Advisor, Reading Execution Plans, Optimizing Indexes, Utilizing Index/Query Hints, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Good at SQL Server Management studio 2008 new and enhanced features like object search, object Explorer details, Intellisense in Query Editor, T-SQL Debugger, activity monitor, Multi Server Query,
• Excellent in Replication strategies for setting up and configure replication (snapshot, transactional, or merge) to copy, distribute and synchronize data across multiple servers.
• Well experienced in installing, configuring and maintaining SQL Server Clusters
• Experience in Data Modeling (Logical and Physical design of Databases) using ERwin
• Experience in data migration (using tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance plan.
• Experience in extracting, transforming and loading data (ETL) from various data sources like Excel, CSV, Oracle, Flat file and text data format using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Extensive experience in SQL/Oracle upgrades and patches.
• Well versed in various high availability solutions like clustering, mirroring, log shipping
• Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems.
• Excellent backend skills in creating SQL Data Objects
• Experience in creation of logins, users and configuring permissions and assigning roles to users
• Experiences in devising Disaster recovery strategies and effectively testing them.
• Experience in managing security, creating security policies and rules
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Server Agent
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Designed and developed business intelligence reports using SQL Server Reporting Services 2005/2008 and integrating it to the front end application.
• Used report manager to create folder structures, modify data sources, controlling access to report services resources.
• Extensive experience supporting databases both on Windows server 2003 and windows server 2008 in a 24x7 environment.
• Experience in working closely with developers and end users
• Good at Windows Batch/PowerShell programming skills.
• Experience in conducting in-depth research and analysis to assess internal and external impacts related to system modifications
• A well-organized, goal-oriented, highly motivated effective team leader/member with excellent analytical, troubleshooting, and problem solving skill to bring effective solution to client.

TECHNICAL SKILLS

Operating System: Win 2003/2008/2008 R2, RHEL, UNIX

Languages: Java, C/C++, SQL, T-SQL, PL/SQL, PowerShell, XML, Visual Basic & HTML

RDBMS: SQL Server / 2000/2005/2008 R2, SQL Azure, Oracle9i/10g/11g, MS Access

ETL Tools: SSIS, DTS, Informatica

Tools: /Utilities: SSMS, Visual Studio 2008/2010, BIDS, Profiler, DTA, TOAD, Perfmon, RedGate, ApexSQL suite, Precise I3, Quest Foglight, Autosys, OEM, LiteSpeed, Office 2007/2010, MS Visio, IIS 7.0/7.5, SharePoint, PowerShell

Reporting Tools: SSRS, Crystal reports

Data modeling Tool: ERwin

Data Archival Tool: Tivoli, Data Protector, Data Domain

Other skills: MCSE, TCP/IP Networking, Hardware troubleshooting

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

EUP Tech Lead

Responsibilities:

• Currently working on the prestigious SQL Server upgrade project involving more than 200 survival critical & mission critical SQL applications in various business segments of Confidential insurance that are both vendor & custom built running SQL2000/ R2 in side by side upgrade mode.
• Gathered the requirements for the application in the form of stack analysis & RFI from application team and perform the analysis of the application and prepare the readiness for the upgrade.
• Ran & analyzed SQL Server Upgrade Advisor reports on the source systems running older version of SQL to capture any breaking changes and deprecated features which could prevent the application from functioning in the new upgraded environment and also used SQL Server Migration assistant to convert and bring in the data from Oracle to SQL Server environments.
• Migrate the databases using backup/restore method and all the dependent objects such as logins, jobs, alerts, operators, linked servers, triggers etc in both physical and virtual environments.
• Keep a track of SQL Server version/edition installation information on the legacy servers and performed de installation and the downgrade of the products wherever applicable in order to reduce the license costs being paid to Microsoft.

Environment: SQL Server 2000/2005/2008 R2, Windows Server 2003/2008/2008 R2, T-SQL, SSMS, SSUA, SSMA, SSCM, BIDS, SQL Profiler, Performance Monitor, SSRS, BCP, DTS, SSIS

Confidential

APP DBA

Responsibilities:

• Worked as an application DBA for one of the prime business segments ( Confidential ) of Confidential to support maintained and monitor existing complex heterogeneous database systems with over 25 SQL Server 2005/2008 instances houses more than 200 databases and 10 Oracle 11g databases in DEV, QA & PROD environments.
• Worked on Remedy tools - Incident Management, Change management & Problem management to resolve tickets based on the priorities so as to meet the tight SLA requirements of the client.
• Worked as an APPDBA in Oracle 11g databases which houses Confidential ’s MAXIMIS, the accounting application data. Principal activities included Database refreshes in lower environment during major code releases, Schema objects creation & modifications, sending a database copy to the vendor for troubleshooting purposes & Maximis application upgrade.
• Created, administered & monitored database jobs hosted on both OEM and 3rd party scheduling tool name Autosys
• Used SQL Profiler, system monitor and precise I3 to analyze, audit and collect the performance data on server, database and query level to maintain server and databases health and to help tune slow running queries & indexes.
• Effectively used Redgate & ApexSQL suite of products such as SQL compare, SQL Data Compare, SQL Source code control, ApexSQL log, ApexSQL recovery etc to help fix developers & business analysts with the database issues they had on a need basis.
• Designed monitors like Audit Failed login attempts, Objects in the Primary Filegroup, Missing backups for any unusual activity which will help our own DBA team to efficiently monitor & audit the databases and thereby keeping the health of SQL Server systems and databases up to date.
• Tuned ad hoc queries and stored procedures for attaining optimal performance using new features like plan guides, online indexing, temp tables and table variables which are helpful in reducing the execution cost.
• Designed couple of Database specific reports using SQL Server 2005/2008 reporting services such as Transaction log monitoring, Long running query & DDL Audit which helped internal DBA team to proactively monitor the database activity and take the necessary action.

Environment: SQL Server 2000/2005/2008 R2, Windows Server 2003/2008/2008 R2, BMC Remedy Suite, T-SQL, SSMS, BIDS, SQL Profiler, Performance Monitor, Database Engine Tuning Advisor, Toad for Oracle, SQL Navigator, Reflection for Unix, Putty, Autosys, OEM, Red Gate, ApexSQL suite, Precise I3, SSRS, BCP, DTS, SSIS, PowerShell

Confidential

SYS DBA

Responsibilities:

• Been part of an elite group of 20 SYSDBA’s that span across geographical areas supporting and maintaining over 100 enterprise SQL Systems with more than 2000 databases running SQL 2000/2005/2008 in a 24x7 highly available SAN replicated shared farm environments.
• Worked on Remedy tools - Incident Management, Change management & Problem management to resolve tickets based on the priorities so as to meet the tight SLA requirements of the client.
• Created & configured maintenance plans for day-to-day operations such as backups/restore, import/export data, update statistics, index reorg/rebuild etc to keep the databases in a healthy state
• Proactively monitored the application and database related SQL Agent jobs running on the DB servers using Job Monitor and promptly fixed the issues upon job failure.
• Maintained and supported 10 SQL Server clusters- Active\passive as well as Active\Active consisting 2 nodes to provide high availability.
• Actively engaged in all the system related activities such as Disaster Recovery solutions, user management, Security administration, Server auditing, database refreshes, server patching.

Environment: SQL Server 2000/2005/2008 R2, Windows Server 2003/2008/2008 R2, BMC Remedy Suite, LiteSpeed, Object level recovery(OLR), T-SQL, SSMS, SQL Profiler, Autosys, Cluster administrator, Precise I3, BCP, SSIS, Performance Monitor

Confidential, Palo Alto, CA

SQL/SSIS, DBA, Data Modeler

Responsibilities:

• Worked with Business Analysts and Customers to gather business requirements for the system and improved the requirement gathering process to ensure strong client standards.
• Participated in Business requirement meetings, JAD sessions and translated requirements into ETL Specification Documents.
• Intensively worked with Business Analysts for Domain analysis and Data analysis to suggest important changes in order to meet the Database standards.
• Designed and developed Conceptual, Logical and Physical model of Database/Data warehouse for projects based on business requirements using ERwin/SSMS
• Involved in project planning, scheduling for database module with project managers.
• Designed, developed, debugged and tested SSIS packages, configuration files and implement best practices to maintain optimal performance.
• Developed and implemented error handling techniques in all the SSIS packages to handle irregular data and minimize failures. Also designed Parent and Child packages to load data in batches, ensuring restart ability, and reduced time with rollback functionalities.
• Created Adhoc reports, sub reports, linked reports and custom reports using Visual Studio, report builder in SSRS and deployed them and published into websites along with integration with SharePoint server.
• Developed packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times.
• Redesigned legacy SSIS packages and converted DTS packages to SSIS packages.
• Created a repository on the Team foundation Server to store all the packages in it for better security, accessibility, and record version history.
• Configured CDC to check SSIS Packages updates to Data warehouse tables for insert and update.
• Extracted and Loaded data from various sources such as MS Access, MS Excel, SQL Server, XML Files, Raw Files, Flat Files and DB2 using SSIS.
• Used various performance tools such SQL Compare and TOAD to improve the performance of the database and maintain standards.
• Used SQL Profiler to analyze the communication between the application server and Database to monitor server activity.
• Tuned stored procedures for attaining optimal performance using new features like plan guides, online indexing, temp tables and table variables helpful in reducing the execution cost.
• Expert in index implementation by finding missing indexes and removing excess indexes involved in degrading performance of server and rebuilding indexes and maintaining up-to-date statistics.
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Worked on linked servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Utilized new features of SQL Server 2008R2 such as Policy based management to enforce security policies, Resource governor and Data collection to actively monitor and control usage of resources
• Used Agile Methodology with single open office sometimes called as Scrum.
• Trained testers on Migrated Data to test application by conducting walk through sessions.

Environment: SQL Server 2005/2008 Enterprise, Windows Server 2003/2008 Enterprise, SQL Server Management Studio, Business Intelligence Development Studio, DTS, SSIS, SSRS, ERwin, T-SQL, VB 9.0, SQL Profiler, DTA, SQL Compare, TOAD

Confidential, SFO, CA

SQL Server DBA

Responsibilities:

• Provided primary support to various business critical SQL Server applications hosted over 50 servers
• Created and enforced SQL Server designed standards to allow for efficient and audit compliant SQL environment
• Upgraded SQL Server 2005 instances to SQL Server 2008R2 and guided the development and application team to fully utilize SQL Server 2008 enhancements
• Used Performance monitor, Database Engine Tuning Advisor (DTA) and SQL Profiler, DBCC commands,, Dynamic views (DMVs), Actual Execution plans to optimize queries and enhance the performance of database servers.
• Worked on reconfiguration and tuning of servers by using appropriate raid levels, configured data, log files and filegroups, tempdb configuration, and security configuration using Transparent Data Encryption(TDE)
• Successfully implemented Database mirroring on SQL 2008 Servers for Disaster Recovery and monitored databases involved in mirroring sessions
• Monitored SQL modules via 3rd party utilities like Idera Diagnostic manager and Tivoli for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks
• Installed, configured and maintained MS SQL Server Replication (Snapshot, Transactional) for production servers to distribute and synchronize databases and its objects
• Managed capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory usage.
• Experienced in tuning SQL queries and stored procedures using online indexing, caching execution plans, temp tables, table variables to reduce execution cost and improve the SQL Server performance
• Created Partition function, Partition scheme and multiple file groups and files to host the table data (consists of over 2 million rows) for Data partitioning.
• Installed and maintained SQL Server cluster- Active\passive as well as Active\Active consisting 4 nodes to provide high availability.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, file layouts etc.
• Worked with the development to enforce security frameworks across various environments from dev to production
• Created various Database maintenance plans at server, database, schema and index levels for maintaining the database performance up-to-date. All results are logged in a central repository
• Automated various DBA activities using SQL Server Agent and Windows PowerShell.
• Played an important role in configuring hardware components and layouts for optimizing SQL performance
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting
• Provided 24x7 production support and necessary documentation for projects to track progress and for future reference and maintenance.

Environment: SQL Server 2005/2008 Enterprise, Windows Server 2003/2008 Enterprise, SQL Server Management Studio, Business Intelligence Development Studio, T-SQL, SQL Profiler, DTA, Performance Monitor, Idera, SAN, Windows PowerShell, Tivoli

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Worked on upgradation and migration of databases from SQL 2000 to SQL 2005
• Used Performance monitor, Database Engine Tuning Advisor (DTA) and SQL Profiler, DBCC commands, Dynamic views (DMV’s), Actual Execution plans to optimize queries, audit deadlocks, user activity and enhance the performance of database servers.
• Maintaining the database consistency with DBCC, DMF and DMV’s at regular intervals.
• Developed trigger and stored procedures and enforced business rules via checks and constraints
• Designed and developed DTS/SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Migrated several applications to SQL Server 2005 and enhanced their performance and functionality by implementing new SQL Server features such as partitioning, service broker, snapshots and row versioning
• Created a uniform maintenance plan to check tables, indexes for integrity, update statistics, DBCC commands, clean up tasks, reorganize/rebuild indexes etc. All information is logged in central repository.
• Configured and maintained SQL Server Replication (Snapshot, Transactional) for production servers to distribute and synchronize databases and its objects
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Resolved security issues by creating new roles and granting required permissions to the users at various levels.
• Created custom-tailored database backup/restore scripts for full, Differential and Transactional backups and scheduled jobs for DBA automation task. Also restored of databases to the different hardware Windows servers configuration using export and import utility.
• Partitioned large tables (1.2 million) rows using partition functions and schemes and thereby improved performance of database.
• Provided support to the application developers on the application databases.

Environment: SQL Server 2000/2005, Windows Server 2000/2003, T-SQL, SQL Server Management Studio, BIDS, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Replication, SSRS, BCP, DTS, SSIS

Confidential

Network Security Consultant

Responsibilities:

• Assisted in implementing all the phases of security policy of the network (Secure, Test, Monitor, & Improve).
• Installation, configuration and basic maintenance tasks of OS up gradation and password recovery of PIX 515/525/535 Firewalls
• Deployed Dynamic and Static NAT & PAT rules with the help of conduits and access-lists to hide the internal IP addressing and to provide secure access to WEB, FTP & Mail servers residing in DMZ.
• Implemented Authentication, Authorization & Accounting services (AAA) via PX Cut-Through Proxy for both inbound and outbound connections using Cisco secure ACS v3.0 and URL filtering through WebSense server.
• Handled advanced protocols like FTP, SMTP, SQL* NET, SIP &H.323 to provide secure communication through PIX without violating ASA rules.
• Configured PIX 535 firewall to support state failover and fail back for redundancy and fault-tolerance.
• Implemented common security measures namely SMTP guard, DNS guard & Flood guard to prevent intruders from being attacked on DMZ
• Installation, configuration and periodic enforcement of signatures on Cisco secure IDS 4210/4235. periodically generated and viewed sensor reports with IDS event viewer and analyzed to take necessary action against common attacks like ping sweeps, port scans etc.
• Installation, configuration and maintenance of web-based Radware’s Fireproof switch load balancers to provide constant connectivity between sites
• Installed and Configured HIDS, VMS server for effective management and monitoring of all security devices using Cisco Works 2000. provided technical support to engineers at 32 RBI locations.

Environment: PIX 515/525/535 Firewalls, Cisco Works 2000, IDS 4210/4235, Radware Fireproof, HIDS, VMS, ACS, AAA, NAT, PAT, ASA, Webzines