SUMMARY

• More then 11 years of experience with SQL Server and 4 years of Oracle, Administration.Successfully consulted in gaming, banking, insurance and oil and gas industry.
• Highly accomplished, deeply driven, IT professional with a successful 8+ year track record of success in Oracle & SQL Server database management, data warehouse design, business intelligence, Query, performance optimization and object - oriented analysis.
• Proven ability to tackle and succeed in all endeavors from high-dollar business development to customized software development and implementation.
• Repeatedly successful in navigating complex technical environments, and possess strong PL/SQL expertise in stored procedures, performance tuning and optimization.
• Exceed ongoing and overlapping deadlines in fast-paced environments, handle multiple assignments simultaneously and coordinate deliverables with key stakeholders in cross-functional groups.
• Applied complete project manager standard industry processes and also conducting sessions on project Management skills.

TECHNICAL SKILLS

Software: Oracle (10g,11g), DB2, Sybase, SQL Server 2005, 2008, Microsoft Access, Erwin, Visio, MS Project

Systems: MS Windows 98/2000/ME/NT/XP, Windows 2000/03 Server

Languages: ASP, ASP.Net, Visual Basic 6.0, XML, DTS, DCP, Rapid SQL, TSQL, PL/SQL, C#, DMV

Networks: TCP/IP, Active Directory, IIS, NAS,SAN,Netapp storage

PROFESSIONAL EXPERIENCE

Confidential - IRVING TX

SENIOR ORACLE/ SQL SERVER DBA

Responsibilities:

• Installation, Upgrading, Configuration, Administration, Cloning, Patching,Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management, Monitoring Applications and its services of the following Oracle Technologies (Oracle Database 11g,10g) Suse Linux and Windows 2000/2003/2008 Server.
• Extensively worked on high availability solutions implementation with Storage Area Network(SAN), Oracle RAC (11g, 10g), ASM, RMAN, Data Guard (11g, 10g, and 9i),AWR,SQLT, creating database backup, recovery procedures to ensure the integrity of disaster recovery process and Oracle Utilities.
• Proficiently in handling multiple roles independently: Oracle Core DBA, Oracle RAC DBA, SQL Server DBA and interacting with business regarding design, planning and implementation of projects.
• Provided 24 x 7 production support for the SQL Server 2008 R2 database and application issues
• Implemented backup archival and logging process in Mysql.
• Provided database support to Mysql 3.x.Also involved in capacity planning.
• Experience with Oracle Data Integrator
• Setup replication in Mysql database.
• Involved with Business Intelligence team in developing SSIS packages for data migration.
• Involved Architecting DW, DataMart Star and Snow Flake Schema.
• Involved in migration for SQL Server/ Oracle databases.
• Experience with terabyte databases, redesigning them for RAC and optimal performance. ASM migrations and tuning on platforms including windows and linux.
• Working with systems team on storage issues.
• Experience with OBIEE Designing and Developing Dashboards

Confidential, San Antonio

DBA /IT Manager

Responsibilities:

• Evaluated ongoing application production/development problems and recommend/justify solutions.
• Oversaw the development of document specifications for all developed/modified code.
• Maintained the physical databases by monitoring Performance, Space utilization and Physical integrity clustered environment.
• Setup control access and privileges in Mysql.
• Involved in data migration from MYSQL to SQL Server database
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, disaster recovery, database consistency check, rebuild indexes, and update statistics.
• Developed standards and guidelines to maintain, develop and administer the SQL Server database. In this regard meetings were held with users of different business areas and a complete Disaster Recovery/Backup Plan for the Database servers was established.
• Worked closely with developers and business associates to quickly resolve any ongoing production problems.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Scheduled maintenance Jobs and Alerting using SQL Server Agent.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in planning & administration of the entire migration and system performance. Also worked on tuning the system to achieve optimization of system resources.
• Interacted with application team on optimization of indexes. Processed application team requests regarding indexes. Helped them in choosing the right indexes.
• Written various Stored procedures for the purpose of application development
• Implemented and maintained database security.
• Tuned SQL statements (e.g.: - Using Indexes),DMV and Stored Procedures.
• Currently have 40 DTS packages transitioned
• Hands On with SSIS. Implemented hundreds of rules in DTSX packages for automated imports daily and weekly.
• Designed and implemented reports using SQL Server Reporting Services SSRS.
• Worked extensively on Red Gate tools for Data Backup, Compare and performance tuning issues.
• Overlooked development in C#, .NET, VB COM and SQL Server programming. Hands on development whenever necessary.
• Transformed complex business logic into Database design and maintained it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008 .
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed/developed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Developed scripts to migrate data and the database objects to/from multiple sources.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in creating front end user interface to allow customers to interact with the application using C# objects and HTML.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Coordinating performance issues related to storage with Systems team.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS) in SQL 2008.
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data in SQL Server 2008.
• Migrated data from different data sources as Oracle and MS Access also from SQL Server 2008 to SQL Server 2008.
• Designed and created logical/physical data model based on business requirements.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load in SQL Server 2008.
• Actively involved in gathering and analyzing stakeholders requirements.
• Performing clustering configurations and installs.
• Created alerts, notifications, and e-mails for system errors.
• Plan analysis and design strategies for enterprise analytics data modeling team to design the new integrated enterprise Data Warehouse, supporting capacity/distribution/support and all customer accounts across gas pipeline and electric grid.
• Conducted interviews with managers, engineers and analysts from various departments regarding business goals and objectives
• Set up dimensions, measures and hierarchies for providing drill down options in the reporting environment.
• Successfully implemented for hazard recovery Log shipping and mirroring in a clustered environment.\
• Conducted 5 training sessions on PMP for company mangers.

Confidential · Austin TX

SQL Server Administrator

Responsibilities:

• Installed and configured MS SQL Server 2000/2005/2008 on clustered and non-clustered servers.
• Performed database administration, software installations, upgrades, applying patches, problem diagnosis, optimizations, cloning, and migrations.
• Involved in planning and implementation of Fail-Over support i.e. Active/Passive clustering of Servers.
• Ensured availability and scalability of database systems via regular monitoring, stress testing, and failover testing.
• Evaluated database/SQL performance and performed maintenance duties such as tuning, backup, restoration, disaster recovery, database consistency check, rebuild indexes, and update statistics.
• Involved in planning & administration of the entire migration and system performance. Also worked on tuning the system to achieve optimization of system resources.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Strong RDBMS experience including SQL, database design, stored procedures
• Interacted with application team on optimization of indexes. Processed application team requests regarding indexes. Helped them in choosing the right indexes.
• Written various Stored procedures for the purpose of application development
• Implemented and maintained database security.
• Performed integrations (Data)
• Plan and deploy Client's first Enterprise Data Warehouse, through successive staged projects, re-architecting Client's Marketing Data Warehouse Systems to provide the core architecture.
• Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Deployed and managed applications in a high availability enterprise server farm, the farm obtained its high availability by using products like Windows 2000 Clusters.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Used Erwin to design a complex database environment
• Created SQL server configurations for SSIS packages and XML & Windows event logs.

Confidential

Senior Software Engineer ·

Responsibilities:

• Worked with business managers, clients and senior management to drive marginal enhancements fix defects and issues, process improvement and manage effective business solutions.
• Managed a team of 6 developers in Austin and offshore providing software solutions & analysis.
• Helped increase company scores significantly in the first six months of managing the team.
• Implemented complete project development life cycle according to PMI standards.
• Involved in the building of the team by hiring and developing team members with the right skill sets.
• Hands on coding in Cold Fusion, ASP.NET, C#, SQL Server, XHTML, XML, Share Point, JavaScript mostly in areas of bugs resolutions and minor enhancements.
• Worked on Office Share point 2007 for the company intranet used to access shared workspace and documents. Implemented Share point in DRRR to manage work flow and team member collaboration and documentation
• Worked with Marketing department to setup their hitslinks report tracking, PPC and customized templates
• Provided technical assistance to team in cross functional tracks such as software development and technical operations.
• Involved in troubleshooting and debugging applications, maintaining an uptime of 98 % isolating failures for the all the SAAS (Software as a service) applications and performance tuning thru code or database script fixes.
• Awarded highest numbers of great jobs in any given quarter twice in the company.

Confidential · Austin TX

SQL DBA

Responsibilities:

• Involved in the installation and configuration of MS SQL Server 2000 and 2005.
• Provided 24 x 7 production support for the database and application issues
• Solved critical production problems and performed point in time recovery plans
• Setup database maintenance plan and monitored daily database activities.
• Generated automated alerts for monitoring database backups, scheduled jobs and server performance.
• Created and configured multiple instances of a database by using Snapshot replication for distributing the workload.
• Worked with development team on new projects that rolled into the production environment and assisted them in tuning the SQL queries using SQL Profiler.
• Performed Database backups (operating system, flat file backups & export/import).
• Coded Procedures & User defined Functions in T-SQL.
• Created / granted login, backup / restore log-shipping, replication, disaster recovery methodology.
• Created database tables, indexes and rules.
• Ensured Server & Application performance tuning and optimization.
• Assisted the Application team in data modeling and T-SQL coding for high priority projects.
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies
• Created and managed complex batch jobs.
• Created complex queries for database auditing purposes.
• Performed database tuning, monitoring, and Scalability Testing.
• Evolved in the creation and maintenance of index using Index Tuning Advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions.
• Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process.
• Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, and KPI’s.
• Created a report model on SSAS cubes.
• Created Drill down Reports, Ad-hoc Reports and Drill through reports using the ROLAP as a source.
• Scheduled packages and different maintenance tasks using MS jobs.

Confidential

Database Programmer Analyst

Responsibilities:

• Served as first point of contact and subject matter expert for the ADM Master Inventory program that tracked all American Express server hardware and software.
• Analyzed, normalized, and imported mass updates to the inventory system.
• Designed, modified, and tested data entry forms and web pages to allow searches and updates to the inventory database.
• Designed and implemented Data Access Pages using MS Access, VBScript, and XML.
• Redesigned a complex data system (that involved using Crystal Reports to pull from Oracle from Dbase and MS Access to merge it all together) into a SQL and Access solution that saved two days worth of report generation time each month.