SUMMARY:

• Total 8 + years of experience in IT, 6 years of experience in SQL server Database Administration and 2 years in Linux Administrator, with thorough knowledge of SQL Server 2000/2005/2008/2008 R2/2012 databases. Experienced in Financial and banking services.
• Supported more than 500 servers in an environment with 50+ applications with more than 500 databases with 500+ GB of database size and even some 1.2 TB (Terabytes).
• Worked on SQL Server 2012 Always on Configuration.
• Experienced in installing, configuring, managing, monitoring, and maintenance and troubleshooting SQLServer 2000/2005/2008/2008 R2 on Active/Active and Active/Passive Clustering.
• Planning and implementation of High availability and Disaster Recovery for SQL Server databases, including Windows 2000/ 2003 Clustering, Log shipping, Replication, Database Mirroring and Database Snapshot.
• Good Knowledge on Software Development Life Cycle (SDLC) principles.
• Converted DTS packages to SSIS Packages for SQL Server 2005 and 2008 Db migration.
• Proficient with Management Studio, Enterprise Manager, SQL Query Analyzer, scheduling regular and on - demand jobs with SQL Server Agent,
• Tracing and monitoring databases activities and performance using SQL Profiler and windows Perf Mon tool.
• Strong knowledge in implementing Backup strategy using Complete, Differential, Transactional, files and file-group depending on Database Recovery Model Simple, Full, Bulk-Logged.
• Experience with high availability systems, 500+ GB databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes.
• Restoring very large mission critical databases using full, differential, and log backups.
• Working Experience in preparing documentation as per organizational standards, designing, implementing, and maintaining complex database applications in financial environments.
• Strong working knowledge with 32 bit/64 bit Windows 2000/2003/2008 servers, Itanium servers.
• Involved in setting up the SQL MAIL in order to send the alerts for job failures.
• Worked in development environment, with knowledge of Query estimation, Index tuning wizard, Database Partitioning and database Optimization techniques.
• Experience with establishing and maintaining security integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, and production environments.
• Solid experience with creating alerts, schema management, database reorganization, data loading.
• Active directory administration in Windows 2003, Windows 2008.
• Proficient in Extracting and transforming Data with DTS in SQL Server 2000 and SSIS (SQL Server Integration Services) in SQL 2005.
• Hands on experience with SQL Server and T-SQL in constructing triggers, joins, user defined functions, views, user profiles, relational database models, data dictionaries, and data integrity.
• Implementing SQL server best practices and improvising server and instance consolidation, understanding of RAID-1, RAID-5, and RAID-10 implementation for highly OLTP environment.
• Implemented Third party tools Litespeed, Diskkeeper, Spotlight for disk saving, monitoring and performance improvement.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

PROFESSIONAL EXPERIENCE:

Confidential, Corvallis, OR

SQL Server DBA

Responsibilities:

• Managed All Production, Development Environments running MS SQL Server 2000/2005/2008 R2
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Involved in Migration of Production Database Servers from SQL Server 2005 to SQL Server 2008.
• Configured and Maintained Replicationsand Implemented Database mirroring for High Availability.
• Implemented and supported Log shipping, Replication and Database Mirroring
• Install Amazon web Services on Linux servers
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Strong knowledge in implementing Backup strategy using Complete, Differential, Transactional, files and file-group depending on Database Recovery Model Simple, Full, Bulk-Logged
• Monitoring and Managing use of disk space and connections and Analyzing and troubleshooting the SQL Server processes and jobs
• Took the responsibility of monitoring and fixing existing snapshot and transactional replications

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Maintaining high availability of SQL servers by proactively monitoring the critical services in a 24*7 support environment
• Analyzing and troubleshooting the SQL Server processes and jobs
• Installation, Administration, Configuration of SQL Server 2000, SQL Server 2005 and SQL Server 2008/2012
• Experience in Database backup and disaster recovery procedures
• Strong communication skills, detail oriented, problem solver and team player
• Strong knowledge in implementing Backup strategy using Complete, Differential, Transactional, files and file-group depending on Database Recovery Model Simple, Full, Bulk-Logged
• Setup and configure Database mail for notification purposes
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Monitoring and Managing use of disk space and connections
• Checking Database health by using DBCC Commands and DMVS
• Involved in moving databases between servers using attach/detach, backup/restore and import/export methods.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Implemented and supported Log shipping, Replication and Database Mirroring

Confidential, San Francisco, California

SQL DBA

Responsibilities:

• Well versed with SQL Server 2000/2005/2008/2008 R2 Installation, Administration and Monitoring, Database Backup and Recovery and day-to-day database monitoring activities.
• Experience in Database backup and disaster recovery procedures
• Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking and tempdb utilizations on servers
• Knowledge in SQL Server 2012 new features in test environment
• Hands on experience with SQL Server and T-SQL in constructing triggers, joins, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Monitored databases' usage & developed a project to provide the monthly report to customer
• Strong knowledge and experience dealing with SQL Server Error Logs, windows error logs, and solving problems
• Created Backup strategy for production and development environment
• Migrated DTS packages to SQL Server 2005 SSIS.
• Solving MS-SQL Server Database production issues as per SLAs, pre-empting problems.
• Involved in meetings to gather information and requirements from the clients
• Solving Disk space, Log files full and database file full related issues on SQL servers
• Configured and Maintained Replications
• Installation and maintenance of Oracle products on Linux platform
• Installed and maintained Oracle 10g (10.2.0.1) on Solaris
• Installed, configured and administered Oracle 10g

Confidential, Santa Monica, CA

SQL Server DBA (Support Engineer)

Responsibilities:

• Installed and Configure SQL Server 2005, 2008, 2008R2 in test, development, and production environment
• Migrated databases from SQL Server in test and production environment
• Configured and Maintained Replications
• Logical and physical database modeling
• Establish and maintain transactional replication between database servers
• Closely worked with business analyst to collect requirements & make systems available ASAP
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup Configured Log Shipping from Production to Standby Server (Running as Reporting Server)
• Developed Database Maintenance Plan
• Install, configure and update different software, update windows patches- service pack for desktop and laptop. Working with Mainframes application for Password reset.
• Report all the issues and present the reports to the team leads and managers. Support Level two and level three users in corporate environment
• Working on Magic Ticketing System to resolve issue created by users
• Windows Server 2000 and 2003 environment
• Perform installation of operating systems and applications
• Daily administration of Oracle Applications R12 and 11gR1/11gR2.
• Installation and configuration of Oracle EBS 11i on RHEL ES 3.0/AS 4.

Confidential

Jr SQL DBA

Responsibilities:

• Install and maintain desktop workstations, printers and peripherals locally and remotely
• Loading Windows OS on more than 400 servers, usingBlade logic.
• Windows Server 2000 and 2003 environment
• Supported more than 1500 servers in an environment with 50+ applications with more than 500 databases
• Logical and physical database modeling.
• Installed and configured SQL Server database software, and associated client tools
• Planned and tested backup recovery strategy acceptable to application Service Level Agreements
• Set up appropriate permissions for users, user groups and accepted security policy
• Installed and configured MS SQL Server 2005. Edited the server registration properties, Created Logins. Managed the object level permissions and security issues of the server.
• Perform proactive monitoring of production MS-SQL Server databases - Automating the monitoring and health checks.
• Used Performance Monitor to monitor CPU, Memory and SQL Server statistics
• Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking, Tempdb utilization on Production servers
• Involved in the setup and maintenance of backup and restore.
• Created Maintenance Plans for performing various tasks on SQL Server
• Involved in reinstialization of replication
• Monitoring blockings, long running queries and take appropriate action
• Monitoring and Managing use of disk space and connections
• Involved in data transfers between various servers using BCP
• Performed successful restoration of many databases

Confidential

Linux Admin/Windows Admin

Responsibilities:

• Installing, Upgrading and Administrating Operating Systems and applying Patching & Packages for applications.
• Setup, maintain and manage the User Accounts and groups.
• Scheduling of automatic repetitive jobs using commands, and shell scripts with Corntab.
• Implementing security for users and systems.
• Install and maintain desktop workstations, printers and peripherals locally and remotely
• Windows Server 2000 and 2003 environment
• Configure/assemble/troubleshoot Desktop PCs/Laptops
• PC and laptop data migration