PROFESSIONAL SUMMARY

• Over 18 years of extensive experience in IT, including 10 years in Database Design, Deployment and Database Administration.
• Operating Systems: Windows, Linux RedHat/CentOS, Novell NetWare.
• Databases: Microsoft SQL Server 2000, 2005, Oracle 8i, 9i, 10g, 11g, MySQL 3, 4, 5.
• Web Servers: Internet Information Server (IIS), Apache.
• Database Tools: Enterprise Manager, SQL Developer, SQL Server Integration Services (SSIS), SQL Analyzer, SQL Profiler, SQL*Loader, SQL*Plus, Quest Toad Suite.
• Modeling Tools: Visio.
• Database Administration, Installation, Configuration, Performance Tuning and Troubleshooting for SQL Server 2000 and SQL Server 2005 under Windows.
• Database Administration, Installation, Configuration and Troubleshooting for Oracle 8i, 9i & 10g under Windows and Linux.
• Extensive experience in Data Migration, OLEDB and ODBC connectivity.
• Database scripting using PHP & Perl for Oracle and MySQL.
• Experience in Scripting with Shell (Bash, Bourne), Perl and PHP.
• Mentored software, hardware, networking and technical support professionals.
• Web application development using PHP, HTML, XML and Microsoft FrontPage.
• Web Master for various domains on an Apache/Linux Server.
• Experience in implementing Open Source web technologies like LAMP.
• People skills: managing medium sized teams with varied professional backgrounds.
• Design and Configuration of LAN, WAN and VPN infrastructure.
• Packaging and testing software for multiple platforms.
• Preparation of Technical Documentation and User Documentation.
• Cross - platform database management and Cross-platform development.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Managing DataBridge for cloning mainframe database DMS II to Oracle.
• Managing Automate task scheduler for various scheduled tasks on Oracle.
• Responsible for SQL Server 2005 servers.
• Participated in migration of data from Oracle and MySQL to DMSII.

Confidential, Irvine, CA

MySQL DBA

Responsibilities

• Installation, configuration, tuning, optimization of MySQL Database instances.
• Support and monitor production and development MySQL databases.
• Resolve the fine tuning issues with the MySQL Servers with Innodb engine.
• Set up the benchmark for server performance events.
• Performance Optimization of the MySQL Servers.
• Setup the failover strategy.
• Setup Backup Policies.

Confidential, Canton, MI

Database Administrator

Responsibilities

• Responsible for Installation, configuration, tuning, optimization of SQL Server Databases.
• Designed, developed and implemented the ETL architecture to support both a bulk data migration facility and the ability to periodically, incrementally update the data warehouse.
• Gathered and analyzed application requirement to build and incorporate the need in SQL Server Database including configuration, system, and scope of database.
• Build database schemas, write SQL stored procedures and create database views.
• Work with technical infrastructure professionals to identify database server hardware and storage recommendations, and web server to database architecture.
• Make changes as needed by developers including stored procedures, triggers, design changes and improvements.
• Use tools such as Visio for logical and physical data modeling and reverse engineering.
• Design distributed data tier to optimize machines, servers, database configuration.
• Maintain development, test, and production.
• Perform backup and recovery of databases, as needed.

Confidential

Lead DBA

Responsibilities:

• Database design, creation of databases, installing SQL Server, installing security patches and capacity planning.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user Databases and restoring them when ever necessary.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks and fixing data corruption in application Databases.
• Data transfers using BCP and DTS (Data Transformation Services) and Import/Export of Database.
• Installation, configuration and monitoring of Replication between two sites.
• Performance monitoring and tuning of SQL servers.
• Partitioning of tables and indexes in order to optimize performance and scalability.
• Monitor and tune SQL scripts. Creating upgrade scripts for production Database and supporting it.
• Implementing disaster recovery procedures and testing the same for disaster recovery purposes.
• Server and Application fine-tuning & trouble shooting. Monitoring SQL Server performance and network issues.
• Administering the SQL Server by creating user logins and roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Experience with tools like Quest Software Toad for SQL Server, Visio, SQL Server Management Studio and SQL Server Business Intelligence Development Studio.
• Experience with Active Directory and Windows 2003 Server.
• Experience with SQL Server 2005 Integration Services (SSIS), SQL Server 2005 Reporting Services (SSRS) and SQL Server 2005 Analysis Services (SSAS), designing and executing packages in Visual Studio 2005.
• Installed and configured Oracle 10g, 9i and 8i database. Applied Patches on Oracle software. Analyzed, designed, redesigned, developed, implemented and maintained Oracle instances and databases.
• Written and maintained generalized scripts to create databases, to get definition of the existing databases, to rename the databases, to monitor and maintain databases and their alert log files and listener log files, startup scripts, shutdown scripts, RMAN backup and restore scripts and export & import scripts.
• Scripts for Creation of Schema and business required Stored procedures and functions.
• Migrated oracle 8 to 8i, 8 to 9i, 8i to 9i and 9i to 10g.
• Loading data from Oracle to SQL Server using Bulk Insert and DTS packages.
• Creating Stored Procedures, functions, triggers for database performance and tuning.
• Maintaining the database: Created and maintained tablespaces. Maintained roles, created and maintained Developer & DBA privileges.
• Monitoring memory, processor, Disk I/O and user connections and fine-tuning.
• Miscellaneous: Contacted Oracle support for technical issues & problems. Furnished Oracle expertise and advice.
• Provide 24X7 on-call technical support and help desk.
• Experience with tools like Quest Software Toad for Oracle and Oracle SQL Developer.

Lead DBA

Lead DBA / Network Support

Responsibilities:

• Installation, Configuration, Administration and Trouble-shooting for Oracle 8i & 9i on Windows and Linux, MySQL 3, 4 & 5 on Windows and Linux and Microsoft SQL Server 2000.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user Databases and restoring them when ever necessary.
• Creating Stored Procedures, functions, triggers for Oracle and MS SQL Server database performance and tuning.
• Cross-platform database management.
• Database scripting using PHP & Perl for Oracle and MySQL.
• Server & Application fine-tuning & trouble shooting for underlying databases.
• Monitoring MS SQL Server, MySQL and Oracle performance and network issues.
• Create and maintain ODBC connection for Oracle and Microsoft SQL Server.
• Monitoring and managing Disk Space, Memory and connection.
• Application development support Visual Basic, Visual FoxPro and Visual C++.
• On call client production support
• Technical Documentation and User Documentation.
• Cross-platform development support
• LAN setups using Windows, NetWare and Linux.