PROFESSIONAL SUMMARY

• Over 7 years of IT experience including SQL SERVER 2008/2005/2000 Database Administration, Development, Performance Tuning and Windows System Administration.
• Possess extensive work experience in Installing, Configuration Maintenance of MS SQL Server 2008, 2005, 2000 versions.
• Expertise in Relational Database Management Systems RDBMS .
• SQL Server 2005 DDL/DML Triggers, Database Mirroring, Migration, Upgrading
• Installation and Configuration of SQL Server 2000 / 2005 / 2008.
• Upgrading and Migrating SQL server 2000/2005 databases to SQL server 2008.
• Creating Databases, Transactions, Tables, Indexes, Constraints, Writing and Debugging Stored Procedures, Triggers, Views, Functions and Cursors using SSMS.
• Expert in Monitoring SQL Server Performance, Troubleshooting using SQL Profiler, Index Tuning Wizard or DTA, Windows Performance Monitor and Maintenance plan.
• Experience in performing Database consistency checks using DBCC Utilities, Recompiling Stored Procedures and Index Maintenance.
• Managed day to day activities like creation of Users, Schemas, Configuring Permissions and assigning roles to users and implement Data Encryption.
• Database Backup, Recovery and Disaster Recovery procedures.
• Experience in implementing many types of high availability such as Clustering, Database Mirroring, Log Shipping, and Replication.
• Monitoring Databases and Server, Estimating the growth of the Databases, and maintain Fill Factors.
• Performance Monitor/Profiler to resolve Dead Locks or long running queries.
• Table Normalization, Relational Database Management Systems RDBMS , Optimization and Maintenance plans, troubleshooting.
• Installation and configuration of Microsoft reporting, analysis, and integration services SSRS, SSAS, SSIS , ETL experience
• ONLINE APPLICTION PROCESS CUBES OLAP .
• SQL Server 2008/2005 Reporting services SSRS .
• Experience in Create Objects cubes, de-normalized tables etc to support BI Analytics type of work.
• Development of Tables, Views, Stored Procedures, Functions, Indexes, Joins, Triggers etc., suiting to business application needs.
• Indexes Clustered/Non-Clustered and partitioning of VLDBs Very Large Data Bases-700GB for improving the Data base performance.
• Creating the SSIS, DTS Packages for Data Migration and Modification using DTS Lookups and transformations.
• Scheduling Jobs using SQL Server Agent.
• Well Experienced in implementing and monitoring disaster recovery solutions like Database Mirroring and Log Shipping
• Experience in 2 years Oracle 8, 9i, 10g, and 11g.
• Troubleshooting system wide problems including Network, database third party software.
• Windows Server 2000/2003 systems.
• Possess skills in Network, OS installation and Hardware troubleshooting.
• Production 24 x 7 support.
• Excellent interpersonal and Communication skills, detail oriented, aggressively penetrating into the root cause, organized and highly motivated.
• Basic understanding of networking, firewalls, load balancers, protocols.
• Extensively worked on Dynamic Management Views DMV's and Dynamic
• Management Functions DMF's .
• logical and physical operators

ORACL DBA

PROFESSIONAL SUMMARY

• Over 3 years of experience in analysis, design, development, migration, testing, support and implementation of Oracle DBA. Oracle Database installations, tuning, backup, recovery, upgrading, maintenance and documentation on oracle 11g R2, 10g R2, 9i, 8.
• Installation, Configuration and Maintenance of Oracle 11gR2/10gR2 database with ASM and even single instance database.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, AWR.
• Managed Oracle and SQL server in High Availability environments using Failover, Clustering, Mirroring, Data guard, Cloning technologies and Replication.
• Upgraded database from 9i, 10g to 11g and migrated data across different servers platforms.
• Database full Backup hot and cold , Data Pump Export/Import, SQL Backtrack and Restore and Recovery procedures using RMAN.
• Space Management, Rollback segments, Undo segments and Capacity Planning.
• Database creation with RMAN jobs and security implementations in Oracle.
• Load Balancing, Startup, Shutdown of Individual instances on RMAN database.
• Installed 10g Grid agent on servers and configure OEM Grid control.
• Data Loading using SQL Loader and DBVERIFY for corruption checking.
• Used parameters to configure, install and manage ASM instance in 10g.
• Experience in maintenance of Production, Testing, Development, Standby databases/ Dataguard for OLTP, Decision Support Systems DSS Data Warehouse environments.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Oracle Streams Replication of database and MV Replication.
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Flash-Back Recovery, ASSM, AMM, ASMM, Recycle Bin.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage, resolving ORA-errors and network management.
• Experience in ERWIN Data modelling and MS Visio for E-R diagrams and Logical, Physical layout designs and experience in scheduling jobs on database by DBMS.SCHEDULER.
• Auditing, Oracle Security, OEM, SQL Navigator, TOAD and Opatch Utility.
• Experience in Very Large Multi Terabyte Database VLDB and using System Development Life Cycle SDLC .
• Partitioned large tables, indexes, implemented local indexing to improve the performance of ETL file loading.
• Documented all Oracle database installations and database operations
• 24 7 Production Database Support to ensure availability, efficiency and recoverability.
• Production users in resolving any of performance issues.

TECHNICAL SKILLS:

Operating Systems Windows Server 2008, Windows Server 2003,Windows 95/98/ME/NT/2000/XP, VISTA RDBMS MS-SQL Server 2008/2005/2000, MS-Access 97 2000, Oracle 10G. Languages C, C , SQL, T-SQL, SQL, SQL PROGRAMMING. Tools/Utilities Enterprise Manager, Management studio, Profiler, Query Analyzer, Export Import, DTS, SSIS-Integration Services, Replication, SSRS-Reporting Services Front End Tools MS FrontPage 98/2000, MS Office 97/2000/XP, MS Project 2000, MS Outlook 97/2000 Database Modeling / Schemas Erwin, UML Web Technologies HTML, DHTML, XML, ASP, Java script, VB Script, Visual Studio, Data Base, shell scripting, Perl, python, and power shell Microsoft products: MS Office Suite- Excel, Word and Power Point

PROFESSIONAL EXPERIENCE

Confidential

Position: SQL Server DBA

Responsibilities:-

• Responsible for Installations and configurations of SQL Server 2008, applying Service packs.
• Installed and Configured SQL Server 2008 and Clustering Services.
• Worked on SSIS packages using SQL Server 2008.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS i.e. Import and Export , BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
• Worked extensively on Data Modeling on creation of new data models add existing tables to the data models and creation of new tables.
• Worked extensively on Data Maintenance like Re-indexing, Integrity Checking, Database Shrinking.
• Installation and Configuration of Reporting Services, Creating Monitoring Reports. Implementation of Point in time Backup and Recovery Plans of all databases and maintain documentation.
• Schedule the Administrative Tasks like Database Integrity Checks and maintenance plans.
• Executed Data analysis and Correction activities.
• Executed Data migrations from one database structure to another Using SSIS Review and Migrated Stored Procedure.
• Involved in Scheduling Tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL Mail, Managing Alerts, Monitoring and Tuning SQL Server, SQL Suggested better Scheduling Strategy for jobs to overcome Blocking and Dead Locks.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Responsible for maintaining High availability servers like Clustering and transactional Replication.
• Worked on a package Migration wizard in SQL Server 2005 to migrate DTS Packages to SSIS, SSIS Package Configuration, and passing variables dynamically and used SSIS Logging.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services SSRS .
• Implemented Disaster Recovery for SQL Server DBA Production Database as Fail-Over or Standby Servers.
• Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Involved in setting up ,managing and maintaining High availability technologies : Log shipping, Mirroring and Replication
• Very good experience in the Maintaining Production Servers, Monitoring Performance issues, Trouble Shooting and Solving Production Issues.
• Created several packages in SSIS
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• SSRS, SSAS, SSIS 2000, 2005, 2008.
• ONLINE APPLICTION PROCESS CUBES OLAP .
• Experience working on Database Engine Tuning.
• Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database.
• Experience in analysis services.
• Data Migration and Data Re-conciliation Approaches
• Project in data migration
• Creating and managing user accounts / logins for development purpose
• Experience in writing SQL code, scripts, and reports.
• logical and physical operators

Environment: SQL Server 2008, SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS Windows Server 2003.

Confidential

Position: Oracle DBA

Responsibilities:

• Installation and creation of 8, 9i, 10g, 11gR2 databases for Testing, Development and Production
• Installation and Upgrading of OEM for Testing, Development and Production on 10g R2.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Extensively worked on setting up auditing in many databases we supported.
• Responsible for optimizing the queries and application tuning.
• Refreshed schema using Export/Import. Created the database, table space, tables, indexes, set privileges and user logins
• Installed and Implemented Backup Recovery procedures
• Partitioning Strategies for very large tables implementing Range, List Partitions, Hash Sub Partitions, creating and refreshing Materialized views Cloning duplicating databases using scripts as well as RMAN
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• Used Secure SCP FTP extensively for the File transfers from machines to remote server.
• Effectively resolved incident tickets in the production environment.
• Installed and configured Oracle 10gR2 database on 10gR2 cluster

Environment: HP-UX, AIX, Windows 2000/2003, Oracle 8, 9i, 10g, 10g R2, 11g R2 UNIX, SQL, Oracle Auditing, Oracle Partitioning, Data Guard, Grid Control, Hot Standby, RMAN, TOAD, SQL Plus, PL/SQL, XML

Confidential Position: SQL Server DBA

Responsibilities:

• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Created reports that call sub reports in SSRS
• Generated custom and parameterized reports using SSRS
• Experience in SQL SERVER Analysis services.
• Designed new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Maintained databases in MS SQL Server 2005.
• Implemented major changes to the MS SQL database for overall performance enhancement.
• Experience in Migration of Database Objects, Packages, jobs and services.
• Involved in resolving Deadlock and Index Optimization.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Developed Stored Procedures, tables, queries, views, DTS packages.
• Implemented Data Transformation Services DTS , BCP, Log shipping and Bulk Insert.
• Production 24 x 7 Environment.
• Experience in data Extraction, Transformation Loading ETL .
• Responsible for Query optimization and Performance tuning.
• Experience in Creating and managing user accounts / logins for development purpose

Environment:

SQL Server, T-SQL, Query Analyzer, Outlook, DTS, BCP, Enterprise Manager, Windows 2000 Server, SSRS

Confidential

Position- SQL Server DBA

Responsibilities:

• Installed SQL server 2005 based on the Requirements.
• Performed Back-up, Restoration of Databases in Full Recovery Bulk-Logged modes.
• Implemented the Security Permissions/Logins utilizing the SQL 2005.
• Performance Monitoring Tuning is done and identified the Reasons for Slow-Running of the System. Ran Trace. Done the Troubleshooting work and rectified the bottlenecks to achieve High Availability.
• Monitored, done the troubleshooting for import export, maintenance, log shipping, replication jobs.
• Implemented log shipping and performed change role.
• Implemented Log Shipping and Replication Snapshot/Transactional/Merge .
• Rebuilt the log shipping standby databases.
• Several times truncate the transactional log file.
• Added the new data files for existing databases.
• Increased the space in existing data files.
• Resolved blocking issues in databases.
• Troubleshot the slow running queries and applications.
• Created indexes, updated index statistics and rebuild indexes.
• Created SSIS packages to transfer the data from development to testing and production.
• Several times truncated the tables and reloaded data into tables.
• Performed strip backup on very large databases ,copied the backup files from source

Server to destination server.

• Restored the database from multiple backup files.
• Installed the SQL server 2005 and applied service packs and hot fixes.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Migrated from DTS packages to SSIS packages.
• Reporting Services/Analysis Services are performed using SSRS/SSAS as and when required by the Company.
• Created maintenance plans for user and system databases.
• Implemented database mail and created operator and assign the operator to jobs.
• Transferred logins jobs SQL server 2000 to SQL server 2005.
• Implemented database mirroring on SQL server 2005.
• Assigned the privileges to newly created stored procedures.
• Supported on call 24 7 on rotational basis
• Performed Data with Microsoft SQL Server 2000/2005, SSIS / SSAS.

Experience in Creating and managing user accounts / logins for development purpose

Environment: SQL Server 2000/2005, Oracle, Windows 2000/2003 Server, T-SQL, PL/SQL