OBJECTIVE

• To secure a challenging position as DBA in a professional environment, that would allow me to utilize my experience, skills, and abilities, for the growth of the organization.

SUMMARY

• Dynamic, achievement - focused and results oriented ITIL, ORACLE Certified Associate and Microsoft Certified Professional with more than 5 years of proven and established performance record in Oracle/SQL DBA, SDLC, System Analysis and global delivery excellence accompanied by Engineering degree in Comp Science and MBA.
• In-depth knowledge and experience in full life-cycle of database including data architecture, logical and physical database design, data modeling, implementation, and administration.
• Extensive experience in planning, installing, configuring, and administering multiple SQL databases
• Solid skills in database optimization and performance tuning for servers, applications, and SQL queries.
• Provided consulting solutions to global fortune clients in database design, database server configuration, data warehouse implementation, server/application performance tuning, backups and restores, including backup strategies for disaster recovery, native backups and backup up to tape/virtual tape systems.
• Experience in designing enterprise-wide database backup and recovery plans and implementing backup/recovery, failover, and replication procedures.
• Experience in business analysis, project management, supervisory, and team leadership
• Adequate knowledge of SDLC and ITIL Methodologies in regards to IT Infrastructure Management.
• Proven leadership skills, brilliant communication skills and comprehensive knowledge base shown during work experience.
• Exceptional ability to enhance value of any engagement and present even the most compound concepts in a simple, clear & concise fashion.
• Highly self-motivated, dynamic, multitasking and goal-oriented individual, equipped with proven ability to take informed decisions even in the most critical environments.

TECHNICAL SKILLS

OS & Languages: JAVA, HTML, XML, .NET, DNN, C, C++, C#, Asp.Net, MS Office, UNIX, Linux, Windows, DOS

RDBMS & Tools: SQL Server 2000/2005/2008 R2, Enterprise manager, SQL Server Management Studio (SSMSE), ORACLEv9i/10g/11g, OEM, Toad, MS-Access, DBMS, Postgres etc

Hardware: IBM Risc and HP/Dell servers, Pentium, and IBM Compatibles etc

PROFESSIONAL EXPERIENCE

Confidential, Houston

DBA

Responsibilities:

• Providing end to end support to AlphaIT by supporting SQL Server databases (2005, 2008)in Dev, Test, & Prd.
• Performed all aspects of SQL server Administration - installation, tuning, and migration of instances, space management, backup and recovery, cloning, setting up of High-Availability and Disaster Recovery Solutions like Mirroring, Replication and Clustering.
• Optimized physical design and environment for different data access methods and monitors performance and provided recommendations for database performance enhancements
• Provided 24x7 and on-call support for SQL server (and few Oracle databases), enhanced existing environments for optimal performance and ensured that all critical database problems are resolved in a timely manner. Coordinated with DBA Team on infrastructure enhancement or large development projects with Shell scripting, database export/import, Hot and cold backups, system tuning and troubleshooting on UNIX and Windows.
• Pre-Release activities which includes Time & Effort Estimation.
• Creating and maintaining DTS\SSIS Packages for various ETL processes.
• Optimizing Stored Procedures, User defined functions, user and developers Pl/Sql co des for better performance of the SQL servers and reducing of the network latency and producing better efficiency and effectiveness.
• Analyzing and understanding the users and developers requirements and regular interaction with the various teams for creating better and optimized PL/Sql queries for their business requirements .
• Preparation for Solution and architecture design, Project Planning & Documentation, Customer Requirement Specification, Customer interaction Co-ordination of the support function
• Experienced designing and executing test cases based on Business Application requirements.
• Flexible and versatile to adapt to any environment and work on any project.
• Involved in review of design documents like SRS (System requirement specification).
• Preparation of User Manual and project documentation.
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills.
• Availability Management - Monitoring availability of critical web applications of The Company.
• Responsible for the performance, integrity and security of the company’s databases and software assets.
• Ensuring optimal functionality and speed of all software systems through best practice data management processes.
• Serves as primary support for the company’s ERP system.
• Assist help desk with end user support for system technical issues.
• Customization of the system to improve business processes.
• Assists all users of the network to optimize their information productivity.
• Support for advanced Microsoft Office projects.
• Ad-hoc data requests from managers.
• Works as a member of the IT team to support all department functions.
• Operates as a business professional to use training and skills to increase the value of the company.
• Builds reports and queries to analyze trends and improve processes.
• Maintains and updates company intranet and reporting platforms.
• Ensures software license compliance.
• Provides secondary support to IT manager and help desk for hardware and network issues.
• Other responsibilities as assigned.

Confidential

Sr. DBA

Responsibilities:

• Provided 24x7 Support for Financial, Business Intelligence (BI), & Data warehouse Information systems of Confidential BANK, largest bank of UAE, by managing their PRD, TST, and DEV infrastructure by administering, monitoring, and maintaining Microsoft SQL Server databases (2000, 2005, 2008 R2) to meet the SLA (Service Level Agreements) requirements for user administration, security administration, 99.9% high availability etc
• Operational responsibilities included monitoring critical databases & ETL processes (ie. Informatica, Oracle and Cognos for the ETL business needs), scheduling jobs, weekly and monthly database backup, databases restoration, Capacity management, Query optimizations, Data Import & Export, Strategic planning to use the best practices and implement High Availability (HA) and Disaster Recovery (DR) Solutions like Mirroring, Log Shipping, Replication and Clustering for OLTP and OLAP (Data warehouse) instances.
• Worked on the Integration of various business applications (ERP, CRM, CLM, CWM) with the SQL Servers for various business requirements and reporting purposes which includes Extraction of data from various sources and then transforming the data and loading the data. Providing various reports from this ETL process. Tools used for the integration purposes are Informatica, Cognos, DTS/ SSIS, SSRS. It involves using technology to organize, automate, and synchronize business processes for marketing, customer service, and technical support.
• Problems/issues resolution discovered via monitoring and alerting processes by deadlock and timeout resolution, failing system jobs, File and table growth, Archiving and purging maintenance, Index maintenance, Wait type analysis etc and performing Root cause Analysis (RCA).
• Responsible for Incident Management, Change Management, Availability Management, Problem Management, and Release Management using tools like BMC Remedy etc
• Designing and implementing data collection processes to allow for long-term trend analysis, created a knowledge base of problems and resolutions, Recommended and implemented database best practices, worked extensively with DTS, SSIS, SSRS, and SSAS including Migration and upgrading activities (from SQL server or 2008), Log shipping, Replication, Clustering with and coordination with onshore and offshore teams.
• Monitored database performance via Database tuning, SQL tuning in combination with end-user query tool tuning, Resource control in the DBMS, and Database reorganization.
• Developed and applied procedures relating to database and application security including passwords for listeners etc. Regularly reviewed and changed access authorizations in order to comply with organization policies
• Configured database mirroring for production databases to provide high availability at database level, created maintenance jobs for database optimal performance, Weekly index rebuilding and data purge jobs created as per end-user requirements, email notification to alert DBA group in case any error occurred at database level
• Led team participation in discussion and future strategic planning of the databases and applications, Innovative and creative solutions for Business Applications.
• Working knowledge and involvement for Oracle 10g RAC Rel 2 databases for optimum performance using ASM technology including RAC configuration and RMAN backup & recovery. Working knowledge of AWR/ADDM/ASH reports to identify performance issues to resolve them in timely manner
• Conference with Clients and managers to plan, discuss and strategize and interface with key stakeholders at various levels (SME’s, Directors, and CIO’s) as per the program requirements..

Confidential

DBA

Responsibilities:

• Maintained 135 Confidential global databases and servers located in USA.
• Complete Management of the databases including daily monitoring, Installations, Security, User Administrations, Troubleshooting, Error Analysis, Documentation, Migration and Upgrade of SQL Server.
• Configured email notifications to be sent through OEM to DBA group for different metrics for database state
• Upgraded Sql server from Sql server 2000 to Sql server 2005 sp2 pack. Applied 10.2.0.5 Oracle patch to different 10.2.0.1 production environments
• Created stored procedures, Cursors, Triggers, Functions to help Developers resolving their issues.
• Strategic scheduling of Backup and Restore Processes to reduce minimum down time of the SQL server.
• Utilized IBM Rational System Architect Software and maintained its Encyclopedia’s and Catalog manager and Synchronizing SQL Server Databases with SA s/w.
• Worked with different versions of oracle from 9i to 11g. Monitored and managed all databases through OEM/Toad

Confidential

DBA

Responsibilities:

• Install, configure, maintain and upgrade database servers
• Set up users and manage security for new users and existing users
• Database planning and management: database files, file groups
• Performed backup and recovery
• Performed database tuning and load balancing
• Query performance tuning using Query Analyzer Execution Plan Diagnostics
• High Availability & Disaster Management Solutions.
• Troubleshot database issues and problems
• Created and implement distributed queries and stored procedures
• Enforced data integrity using normalization, constraints, rules, and triggers
• Created SQL scripts to automate routine administration function,
• Performance Tuning, Backup server, handling the Ftp Accounts, VPN accounts, giving support to the clients regarding the issues their sites are facing and Server maintenance
• Designed and developed the overall architecture and physical implementation standards for Oracle databases.
• Performed database backup, recovery, enforce data integrity and security where necessary, Capacity Planning with the management staff, SQL Server documentation as needed

Confidential

DBA/Analyst

Responsibilities:

• Liaison with the development Team, provided support for Analysis, Design & Maintenance of Databases for Medical Institution portals.
• Extensively worked with tools and products from Microsoft, Oracle, HP, Dell, Compaq, IBM, SUN, EMC, VMWare etc
• Proactively evaluated, implemented and continuously improved the enterprise system and application management framework and system automation in regards to Storage, Backups and DBA functions like performance analysis, tuning, capacity planning, implementing backup and recovery strategy for application and database.
• Experienced with testing tool applications (regression and load) and sound testing methodologies for integrating and interfacing applications.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
• Proactively monitored database systems to ensure secure services with minimum downtime (both SQL Server and Oracle interface).
• Led design and implementation of software for Business and Financial Applications using Oracle 11i and PeopleSoft CRM, ERP, SCM, T&L, Budgets, Data Warehouse, Financials and HRMS
• Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
• Trained developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
• Responsibilities included writing data conversion scripts in PL/SQL for a large database, SQL*Loader control files, database packages, procedures, functions for critical business applications, application and database tuning, and coordinating user testing and acceptance.
• Managed database administration of MS SQL databases, provided support for Hospital Management System and Print/Interactive Media Software’s
• Served as webmaster for client portal. Responsibilities included creation, updating and maintenance of site pages, using CSS, HTML, JavaScript, MySQL, and Adobe Flash. Maintained internal tools for managing site structure, news data, and photos. Assisted with design efforts for site pages, content archival, photo galleries, video features. Provided technical support for usability issues and critical site problems, as needed.

Confidential

Technical Support Executive

Responsibilities:

• Online/Offline Software and Hardware troubleshooting of HP PC’s. Technical know-how of HP PC’s Protection mechanism - BIOS Enabled Protection
• Helped customers setup Small Office and Home (SOHO) networks and worked with QA team to improve processes - Test Plans & Scripts
• Responsibilities included analysis, design, development, and documentation, Writing scripts for query and report modules. Unit, System and Integration test including Black Box, White Box testing and Preparation of Release Document and User manual.