PROFESSIONAL SUMMARY

• Has 18 years of rich and diverse experience in different databases, analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments
• Very good experience in Installation, configuration and maintenance of Oracle/SQL Server.
• Worked with large Databases sizes 175gb in SQL server Environment
• Experience in Data Modeling Logical and Physical Design of Databases , Normalization and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good T-SQL Programming skills. Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures.
• Experience in Replication Snapshot, Merge and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Extensive experience with Oracle 9i Database, Replication, performance tuning, data warehousing, Materialized Views, backup and recovery, RMAN etc.
• Expertise in Oracle version from 7.x 10g and MySQL 4.x 5.1
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.
• Sound Knowledge Experience in MS SQL Server 2008/2012.
• Used AGILE methodology in Software Development process.
• Performed Developed a best practices related to Security and Privacy
• Had sound knowledge Experience in SSIS
• Worked in OLTP OLAP environment that includes Production 24x7 , QA and development databases in SQL Server.
• Experience in SharePoint 2010 has an administrator
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store ODS .
• Has Knowledge hands on experience in SSAS, SSRS, SQL Server Clustering and Log Shipping
• Had a methodology and Experience in identify and debugging reports.
• Has very strong background in a disciplined software development life cycle SDLC process and has excellent analytical, programming and problem solving skills.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
• I have responsibilities in designing document database of architecture. I build data scheme, tables, and procedures. I am a hard worker with compatible attitude.

TECHNICAL SKILLS AND CERTIFICATIONS

• Operating Systems: UNIX, Sun Solaris 5.8, Linux, windows 2000/2003/2008/2012/NT/XP
• Databases: Oracle 7/8/8i/9i/10g, SQL Server 2005/2008/2012, MySQL, DB2, Sybase, MSSQL,
• Microsoft Access 2000
• Languages: SQL, advanced PL/SQL, Java, XML, HTML, JDBC, Swing, Java Beans,
• Applets, JavaScript, JSP, Java-Servlets, ColdFusion4.5
• Oracle DBA tools: OEM, User-managed and RMAN Backup and Recovery,
• Import/Export utility, SQL Loader, Oracle RAC
• SQL tuning: TKPROF, SQL Trace, STATSPACK, OEM
• Case Tool: Designer 2000 v 1.3.2, Erwin Data Modeler 3.1/4.1.4
• Reporting Tools: Business Objects XI, SSRS
• ETL Tool: Informatica 7.1/6.2, Ascential Data Stage V 7.5 / 7.1/7.0 / 6.0, SAP-BW 3.1,
• SSIS
• Other Tools: Oracle Developer 2K Forms and Reports, Oracle Graphics, Oracle Discoverer,
• MS Project 2000, SOX, MS Visio 2003, SQL PLUS, PL/SQL Knowledge Expert,
• TOAD, SQL Navigator, IQ Objects, T-SQL
• Hardware: IBM e-Server, HP ProLiant ML 110, Dell 6650, Compaq Proliant ML 330/ DL380.

PROFESSIONAL EXPERIENCE

Confidential

Role: Database Administrator/Data Architect/Database Analyst

• Confidential is the fastest growing Insurance Company in the region and hiring continues due to their successful new marketing programs. Confidential offers its agents' value added' marketing services in addition to a portfolio of competitive products. These services include seminar systems, lead programs, on-line marketing systems, product and agent sales training, and much more.
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Design, document, and promote security best practices , policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load ETL development using SQL Server Integration Services SSIS .
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS .
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008/2012.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Used Policy Based Administration feature SQL Server 2008 .
• Worked With 'upsert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic SQL Server 2008 .
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Developed plenty of reports using SSRS and Crystal reports.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Sound Knowledge and experience in SharePoint 2010. Administration functions including deploying code solutions .wsp , PowerShell scripts, server optimization, server management, term store maintenance, taxonomy, content deployment, web and service applications in Central Administration
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.
• Responsible for merging two different version of MySQL database.
• Did data migration from MySQL to PostgreSQL.

Environment: MS SQL Server 2005/2008/2012 , T-SQL, SSIS, SSRS, AGILE, Crystal Reports, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008/2012 Server, PostgreSQL, SharePoint 2010, MySQL 4.x, 5.1 , SQL Yog.

Confidential

Role: Database Administrator / Data Architect/Database Analyst

• Med Remote provides complete transcription processing solutions for healthcare. It is a leading innovator in healthcare transcription workflow solutions.
• Designed, implemented and documented oracle Data Guard physical and logical standby Database disaster recovery solution.
• Maintain high availability of databases for 24/7 global operation using Oracle RAC
• Databases on Linux operating system
• Involved in Implementation and configuration of OEM, Oracle Management Server for
• Maintenance and monitoring.
• Performing Partial, Complete and Metadata Exports Imports.
• Production and development for oracle 9i 9.2.0.5 database administration activities.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Tuned SQL queries using TKPROF and EXPLAIN Plan
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.
• Prepared the weekly and monthly database health report for Med Remote oracle 9i database.
• Actively involved in monitoring the lock processes, releasing locks in case of resource
• Blockage and gathering statistics.
• Involved in understanding the scope of the application, present schema, data model and defining relationship within and between groups of data.
• Involved in developing the process for extracting, cleansing, transforming and loading the data into a staging area.
• Unit tested various scenarios to ensure that the job design and developments within the jobs meet the requirements.
• Taken good initiative in participating the requirement meeting with the Business and System Analysts and gathering information with an ETL and Business Perspective.
• Worked in par with the documentation procedures and ETL Standards within the company so that the jobs designed and developed are in pace with the future enhancements.
• Done the DB2 partitioning DPF
• Used Quest TOAD to tune query performance.
• Did data migration from Oracle to DB2
• Involved in Data Migration from Legacy application to Product application by using SQL Loader.
• Responsible for Creation of new oracle user, and do the import and export of the oracle Database dump.
• Writing PL/SQL Procedures, functions and Data base triggers.

Environment: Dell 6650, Red Hat Linux 2.0/ 3.0, Oracle 8.1.7.4/ 9.2.0.4/9.2.05/10g, MS SQL Server 2005/2008, DB2, Windows XP/2000, DB2, SQL plus, Shell scripts, OEM, PL/SQL, Vi- editor, ER Win Data Modeler, Ascential Data Stage 7.5, Business Objects XI, Oracle 10 g, Aqua Data Studio 4.7.2, PVCS Tracker 6.0.

Confidential

Role: Database Administrator / Data Architect /Data Analyst

• Responsible for System Design, Analyze by using Confidential Data Modeler.
• Responsible for creating and maintenance of Data base and Data base objects by using Erwin Data Modeler.
• Responsible for supporting development team in implementing database and code changes. Performed recovery / refreshing of development and QA environments as and when needed.
• Responsible for assessing, deploying and tracking changes to the development/ QA/ Stage and production environments.
• Installation of Oracle 10g, Creation of Oracle Users, Creating and Managing Oracle Table spaces, Re-Indexing.
• Data Migration from One Oracle Application User legacy system to another Oracle Application User.
• Done table partitioning using DB2 partitioning features.
• SQL, PL/SQL tuning, performance tuning for overall performance. Introducing architectural improvement to eliminate performance bottlenecks.
• Responsible for developing and testing SQL, PL/SQL stored procedures, functions and
• Data base Triggers.
• Implementation and configuration of OEM, Oracle management server, for maintenance and monitoring

Environment: Windows 2000 servers, Erwin Data Modeler, Red Hat Linux 2.4.18, Oracle 9i/ 10g , DB2, Citrix, OEM, SQL Navigator, TOAD, SQL Plus, Windows Terminal Services Client, Oracle Developer/2000 Forms 6i, Reports 6i , Oracle Discoverer.

Confidential

Role: Database Administrator/Data Architect/Data Analyst

• Experienced in Oracle database installation, capacity planning, Confidential Configuration,
• Physical and logical database design, upgrade, patches, monitoring database and
• OS Windows 2000 performance
• Installed Oracle 8.1.7.0.1 , applied patch set 8.1.7.4 and upgraded the databases to 9.2.0.4
• Infrastructure Setup and Database implementation which include design, installation,
• Creation, backup and recovery procedures, RAID Configuration plan, testing,
• Production-rollout and documentation.
• Performing Partial, Complete and Metadata Exports Imports.
• Database monitoring for deadlocked process and maintaining logs/Backups using Import/Export Utilities.
• Automating processes, scheduling jobs per user requirements. Logical and Physical Modeling.
• Writing scripts for monitoring the database, Configuring SQL Net, Integrating multiple application databases.
• Performed Hardware and Software requirements analysis and proposed project plan for
• System upgrade to 9.2.0.5 with standby database.
• Supporting the junior DBA's various routine DBA tasks, PL/SQL best practices and
• Database performance tuning practices.
• Responsible for developing and testing SQL, PL/SQL stored procedures, functions and
• Data base Triggers.
• Implementation and configuration of OEM, Oracle management server, for maintenance and monitoring.
• Tuned SQL queries using TKPROF and EXPLAIN Plan ,Performed TSPITR using
• Confidential by creating Auxiliary Database.

Environment: Windows 2000 servers, Erwin Data Modeler, Oracle 8.1.7.4, Oracle Developer/2000 Forms6i, Reports6i , Oracle Discoverer, SQL PLUS, Toad, SQL Navigator, Citrix, Remote Desktop Connection.

Confidential

Role: Database Administrator / Sr. Project Manager

• Done the Pre-sales activity of Confidential Freight Forwarding Application
• Implemented the ORION Freight Forwarding Application, ORION Trading Application and Interfaced with Legacy Accounting Application.
• Installed Oracle 8.1.7.0.1 , applied patch set 8.1.7.4 and upgraded the databases to 9.2.0.4
• Completed - Infrastructure Setup and Database implementation which include design, installation, creation, backup and recovery procedures, RAID Configuration plan, testing, production-rollout and documentation.
• Performed Hardware and Software requirements analysis and proposed project plan for system upgrade to 9.2.0.5 with standby database.
• Design, implement the BOE and 3PL Modules as per the Business Requirement.
• Implementation and configuration of OEM, Oracle management server, for maintenance and monitoring.

Environment: Dell 6650, Windows 2000, Oracle 9.2.0.4, 8.1.7.4 , Oracle 9i 9.2.0.5 , Oracle Developer/2000 Forms6i, Reports6i , Oracle Discoverer, SQL Plus, TOAD, SQL Navigator, Citrix, Remote Desktop Connection, PL/SQL Knowledge Expert.

Confidential

Role: Database Administrator

• Involved in the Study and Implementation of Container Control, Import, and Export Modules of Shipping System.
• Preparation of Business Solution Mapping document, Functional Technical Specification Document.
• Supporting the Development Team for the development of Container Control, Import and Export Modules
• Involved in Installation of Oracle 8i/9i
• Presented Existing Shipping Application to the Client.

Environment: Windows 2000 Professional, Oracle 8i/9i, Oracle Developer/2000 Forms6i, Reports6i , Oracle Discoverer, TOAD, SQL Plus, SQL Navigator, Citrix.

Confidential

Role: Database Administrator / Data Architect

• Implemented the Confidential in Major Shipping agents in India. The clients like MSC, Merchant shipping Services, Oasis Shipping Services, Samsara shipping, Hind freight.
• Responsible for Design a data base and data base objects by using case tool Designer 2000
• Implemented the ERP application across 35 locations in India.
• The Shipping Management System is developed as per the Client Requirement and is developed for one of the Major Shipping Line MSC, China shipping, TSL
• This system will provide all the information related to the Shipping Agencies.
• This System consists of the following Modules namely System Admin, Capital, Documentation, Container Tracking System, Voyage Accounting, Customer Management System, Tariff Definition, User Management System and various Modules related to the transactions can be created in Static Masters
• Necessary Reports are created for the above developed modules using strong oracle report tools like Reports 6i, Discoverer.
• Study the EDI Structures based on that prepare a detailed level functional specification document.
• Having sound knowledge in Port system and done the interface with port system AFSYS
• Involved in System Analysis Design on Interaction with Clients, Screen Designing, Backend Procedures, Database Maintenance, and Creation of Forms and Report
• Involved in Maintenance of Application server and Web server

Environment: Oracle 8i, Windows 2000, SQL PLUS, SQL Navigator, Oracle Developer/2000 Forms 6i, Reports 6i , Oracle Discoverer, Oracle Graphics, Citrix, Remote Desktop Connection, FTP Server, VNC Server.

Confidential

Role: Database Adminstrator / Data Architect

• Successfully Implemented Shipping Agency System in Confidential.
• The Shipping Management System is developed as per the Client Requirement and is developed for one of the Major Shipping Line Confidential.
• This system will provide all the information related to the Shipping Agencies. This System consists of the following Modules namely System Admin, Capital, Documentation, Container Tracking System, Voyage Accounting, Customer Management System, Tariff Definition, User Management System and various Modules related to the transactions can be created in Confidential.
• Primarily involved in analysis design, screen designing, backend procedures, database maintenance, and creation of forms and reports
• Involved in the developing reports for the above by using the strong oracle reports tools like Reports 6i, Oracle Graphics and Oracle Discoverer.
• Installed the OS with patch and also installed the Oracle 8i.
• Installed the developer 2000 in all the client's user's Pc's and Involved in Onsite development has done as per clients requirement.

Environment: Oracle 8i, Windows XP, Windows 2000 Professional, Oracle Developer/2000 Forms 6i, Reports 6i , Oracle Discoverer, Oracle Discoverer, FTP Server, Citrix, SQL PLUS, SQL Navigator.

Confidential

Role: Junior Database Administrator

• Involved in Implementation of Oracle Financials Modules. The Implementation of the module includes, HRMS, GL, AR AP, apart from that involved in the customization of Payroll, CM, OSA, Card System, and Utilities.
• OSA - Product wise cost for Petroleum Products
• Card System - Swapping cards like Master / Visa
• Utilities - Water electricity, Etisalat
• Payroll - Salary Details
• HRMS - Recruitment, Training, Timesheet
• CM - Bank Reconciliation, Petty Cash
• Involved in database maintenance like management of rollback segments included the estimation of the optimal size and decreasing the rollback segment, done performance tuning by creating clusters and indexes.
• Effectively managed the available space by changing the storage and space management parameters, conversion of non oracle data into oracle data using SOL Loader, Optimizing the
• Query and choosing the right access path by using 'RULE BASED' 'COST BASED', Backend procedures, and Creation of Forms and reports.

Environment: Windows NT, Windows 95, Oracle Application 11i, Oracle Developer/2000 Forms 6i, Reports 6i , SQL PLUS, SQL Navigator, PL/SQL Knowledge Expert.

Confidential

Role: Junior Database Administrator

• Confidential Travel Management System or named product of Information Dynamics is a back office system, which is used to maintain the information related to the travel industry by maintaining details. This system has been classified into 3 modules. Static master creation, Stock Transactions, Ticket Transactions and necessary reports that provide the detailed information for the transactions made.
• Involved in writing procedures based on Client's requirements and providing technical support for the Clients, Forms and Reports, and Backend.
• Involved in the development of oracle forms and oracle reports.
• Developed more than 45 oracle reports and 23 forms in Onsite.
• Design a Sales review module in client place and implemented the same as per clients requirement

Environment: Windows NT 4.0, Windows 95/98, Oracle 7.3.4 8i, Oracle Developer/2000 Forms 4.5, Reports 2.5 , SQL PLUS, SQL Navigator.

Confidential

Role: Junior Database Administrator

• The System is full-fledged Shipping and Freight Forwarding System interfaced with Oracle Financials. The System provides Documentation, EDI, and Notification to Consignees, DO, Invoice, Receipt, and Freight Collections. The System is having advanced features like B/L Number Generation, Correctors, B/L Printing, Load/Discharge List, and Commission Calculation. For Freight Forwarding Job Sheet preparation, Air/Sea Cargo details, Cost for each activity Job , Consolidated Invoice/RCT Job , AWB/BOC details, Profit share details AWB/BOL Wise , Facility to calculate commission on supplies. This System is Designed and developed in Client place DOHA Qatar
• Involved in System Design, Analysis, Forms and Reports, Backend procedures, and providing technical support for the clients.

Environment: Windows NT /Windows 95, Oracle 7.3.4, Sybase, Designer 2000, Oracle Developer/2000 Forms 4.5, Reports 2.5 , SQL PLUS, SQL Navigator.

Confidential

Role: Senior Programmer

• This System is developed for trading company, which deals with multiple products like selling of leading brands of Medicines, Baby Food Products, Skin Care Products, and Machinery Etc. The System takes care of controlling invoices and payments, Parties outstanding, item wise Monitoring.
• Responsible for developing reports as per clients requirement, reports like item wise sales
• Reports, Area wise sales reports, Dealer performance and MIC reports.
• Responsible for writing DB Triggers, Procedures, Functions
• Responsible for developing forms reports as per the Functional Specification Document.
• Involved in Major Support for the System and bug fixing.

Confidential

Role: Programmer

• The Production Planning and control System was developed for production unit of Inter Power Equipment's. The Production and Planning Control System was designed using modular approach by applying drop down modular design and analyzing the complete system by studying the current manual process operations, data analysis, documenting activities, drawing data flow diagrams to describe the relationship between activities and derived functional modules and their specification.
• Involved in Database design, identifying Key elements, Master details relationship, entity constraints, data validation rules and various roles to access the Database, Backend Procedures, Forms and reports.

Confidential

Role: Programmer

• The Payroll Processing system comprises of attendance Module, Loan Module, Pay Maintenance and employee personal details. The advance feature of the system is Auto Generation of daily attendance reports. Involved in the Development of Forms and Reports, Backend Procedures, Major Support for the System and bug fixing application program.