Data Sql Server
Resume:
Mohammed Ali
acy3yy@r.postjobfree.com
PROFESSIONAL SUMMARY:
* ***** ** ******* **********, 7+ years oracle database administration experience supporting a variety of mission critical applications in enterprise and production environment.
Experience in planning, design, install, configure, perform upgrade and maintain oracle 9i, 10g, 11g (release 1 and 2) and 12c across multiple platforms, like Sun Solaris, RHEL, AIX, HP-UX.
Proficient in Install, upgrade, clone, administrate, patch and troubleshoot oracle databases.
Thorough knowledge of various Oracle tools like OEM with management pack, RMAN, SQL Loader, TKPROF, Statspack, AWR, ASH, ADDM TOAD, SQL trace to perform day to day job.
Proficient in installation, configuration, administration, patching and maintenance of ORACLE 10g/11g/11gr2/12c RAC multi-node cluster and add/remove node as per need.
Extensive experience in configure, implement, maintain and troubleshoot errors of physical and logical standby databases [DataGuard].
Experience in replication, extract and apply on production using Golden Gate.
Extensive experience in installation and maintenance of OEM 11gr2/12c Database & Grid control for database monitoring, performance and diagnostics.
Extensive experience in oracle database implementation, configuration, administration and management on Exadata Platform.
Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flashback Technology, Log Miner.
Extensive experience in logical and physical data modeling and database design using Oracle Designer, DBArtisan and Erwin.
Backup and Recovery strategy development (hot / cold) and implementation with through understanding of Database Recovery Scenarios.
Proficient in UNIX and Linux Shell Scripting, Oracle Net, TCP/IP, Stored Procedures, Functions, Cursors, Triggers and PL/SQL programming.
Extensive experience in Security management using auditing, performance monitoring / tuning / troubleshooting on various levels, storage management, data migration from other databases to Oracle, Oracle/Crystal Reports and Cloning & Replication of Oracle Dat1abases.
Complete Oracle lifecycle experience from concept to design, architecture, hardware selection, installation & patches, configuration, database security & space management, performance monitoring & tuning, data integrity, backups & recovery planning and 24 x 7 supports.
Technical Skills:
Tools: DBCA, TOAD, OEM Grid Control, RMAN, RAC, Erwin, Quest Central, PL-SQL Developer, OWB 11gR2, DB Tools, DBArtisan, OTM, TSM, TDP, GoldenGate.
DBMS: Oracle 10g, 11gR1/2, 12cR1, Oracle EBS, Exadata, MSSQL, MS Access, MySQL.
Languages/Platforms: Forms/Reports, OBIEE, Designer, Import/Export/DataPump, SQL, SQL*Loader, SQL*Plus, C/C++, Java, Siebel Analytics, Perl/Shell programming
Operating Systems: RHEL, AIX, Sun Solaris, HP-Ux, UNIX, DOS, Windows 2003/2000
Education:
Bachelor of Engineering, Jawaharlal Nehru Technological University, India
Professional Experience:
Visiting Nurse Service of New York (NYC, NY)
Oracle DBA Dec 2014 - Current
Role:
Designed, Developed, Maintain and Administrate Oracle databases on HP-UX, Linux, AIX and Exadata platforms. Implement, upgrade, maintain Oracle Enterprise manager tool also setup and monitor all OS, RMAN, Corrective Actions and Backup Validation jobs for database.
Responsibilities:
Performed fresh Installation, Configure, Administrate and Maintained Oracle 11gr2/12cR1 databases.
Participated in oracle 12c upgrade, administration and golden gate training from oracle.
Performed Oracle Grid Infrastructure, database upgrade from 11gr2 to 12cR1 by command line and Golden Gate.
Created step by step instruction checklists/documents for database design, installation, patching, upgrade and administration for Dev/SysTest/UAT/TRN/PROD Environments.
Worked closely with project managers, middleware tools teams for Tuxedo, WebLogic & WebSphare, testers and developers to provide best application performance.
Provided access of database and grant required permissions and audited actions of tools & testing team.
Involved in analysis and development of data warehousing applications.
Setup auto alerts and corrective action jobs from OEM and LDAP for OBIEE application servers.
Implemented user and object level security, data encryption, data masking, fain grained auditing using DBMS packages.
Performed database and SQL tuning to lessen performance impact after oracle 12c upgrade.
Performed large batch jobs and tuning of SQL queries and database systems.
Provided assistance to client in database configuration and administration on Exadata Platform.
Configured and maintained Production database replication to client site using Golden Gate.
Used Model Mar of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
Performed adding/removing a node on test server cluster for production POC and added node on Production Environment for high availability.
Used data-guard to minimize downtime in Production server upgrade project.
Used active database, ASM Copy, RMAN and Data Pump to copy/create database for development/testing team.
Involved in designing, assembly and tuning of database for development teams.
Performed installation, upgrade, patching and configuration of OEM Cloud Control and Agents for database, RAC, Exadata monitoring and data masking.
Scheduled auto maintenance and corrective actions jobs in OEM to reduce
Supported Dev-UAT-PRD Environments with regards oracle installation, configuration, patching, database backups and assistance to developer with oracle and OWB issues, also add, remove, configure, support OWB workspace and troubleshoot OWB services when necessary.
Written K/Bash shell scripts for auto monitoring, backup validations and other corrective action tasks.
Environment:
Oracle 8i, 11gR1/2, 12cR1, Grid Infrastructure 11gr2, 12cR1, MSSQL 2k3/8, Golden Gate, RAC, Exadata, OBIEE, OMS 12c, OWB, Toad, SQL Developer, Erwin, Oracle on RHEL 5/6, HP-UX, AIX, Windows, Tuxedo.
ConocoPhillips. (Houston, TX)
Oracle DBA June 2013 - Nov 2014
Role:
Designed, Developed, Maintaining and Administrating Oracle and MySQL databases on various platforms. Participating project meetings, analyzed the business requirements, maintain and perform knowledge transfer with the client DBA.
Responsibilities:
Performed fresh Installation, Configure and Administrate Oracle 11g.
Supported the application and GUI team to design and develop data models for the current and future CRM applications.
Develop documentation related to design, build, deploy and maintenance best practice for Dev–Prod–CRM databases.
Design / Develop / Deploy logical and physical model into various environments to support application Dev-Prod-CRM launch related activities
Conducted data model reviews with project team members and client.
Worked closely with project managers, programmers and testers to database integrity and security and generated test data and tested new database consistency with existing database to meet the functionalities requirements.
Performed Change Control Process
1Prepared documentation, following process and procedures
Created and modified triggers, cursors, functions and procedures.
Experienced with logical and physical data modeling and database design using Oracle Data Modeler.
Performed migration between MySQL-Oracle and loaded the data using SQL Loader
Performance Tuning at DB level, OS level and Object level.
Environment:
Oracle 11g (11.2), Oracle Application Release 11i, MySQL DB, Oracle Data Modeler, SQL Developer, Erwin, FileMaker Pro, Oracle on Linux, MySQL on OS X.
Level 3 communications (Broomfield, CO)
Oracle DBA May 2010 - Apr 2013
Role:
Supporting numerous Oracle databases on RHEL, AIX and Exadata platforms for enterprise mission critical applications, participated project meeting, analyze the business requirements, interviewed the application users, application developers and managers to identify the information requirements, and incorporated the enterprise and the application mission statements as well as the system hardware/software specification.
Responsibilities:
Checked configuration and performance of existing including data file allocation, index, fill factor, fragmentation and impact on system performance.
Analyzed and tuned the DB to identify potential database issues such as response delay, locking contention, even server down time by using tools like Statspack, explain PLAN and TKPROF.
Monitored and tuned database to optimize the performance and satisfy the availability requirements of multiple applications using (STS) SQL Tuning Set and (STA) SQL Tuning Advisor. Analyzes the data by (ADDM) Automatic Database Diagnostic Monitor in the (AWR) Automatic Workload Repository.
Created the new database objects compiling with (OFA) Optimal Flexible Architecture.
Modified existing database structures layout such as disk configuration and storage allocation, also involved in restructuring some query with change in data model to enhance application performance.
Provided suggestions to server administration tem regarding disk configuration, RAID according to database sizing and capacity planning. Fully utilize Metalink to maximize Oracle support.
Maintained day-to-day production support thereafter, check alerts, activity logs, error logs to capture any possible errors to ensure the databases health.
Performed installations and management of performance for data warehouse.
Performed data migration from multiple Prod Exadata databases to warehouse spaces.
Used OEM to monitor, administrate & troubleshoot data warehouse processes, Exadata, RAC and DB Health and automated tasks.
Migrated databases of windows server to UNIX servers for new application integration.
Devised, developed and implemented sophisticating backup recovery strategy using RMAN with VERITAS and designed/implemented disaster recovery test.
Performed implementation, performance tuning and troubleshooting of GoldenGate.
Developed and implemented database maintenance procedures.
Capacity Planning for both OLTP and Data mart - Allocating system storage and planning future storage requirements for the existing and new databases.
Involved in troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security, research and development, architecture, design and support.
Environment:
Oracle 11g (11.2), Red Hat Linux, AIX, Exadata, Win 2000 Advanced Server, Oracle Designer, PL/SQL, OEM, RMAN, RAC, Erwin, OLTP, ADDM, AWR, GoldenGate.
ICICI Bank (Hyderabad, INDIA) Jan 2009- Mar 2010
Oracle DBA
Responsibilities:
Installed, configured and maintained Oracle 10g on Linux also upgraded from Oracle 10g to 11g.
Implemented Oracle Database 10g two node Real Application Cluster (RAC) using Oracle Cluster-ware and was responsible for high availability and load balancing.
Configured Oracle Data guard for Oracle Disaster recovery.
Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
Created and modified procedures, triggers and functions.
Created all administration tasks of SQL Server and designed database.
Used system stored procedures and DBCC commands.
Planned Replication set up for banking software between SQL Server 2000 and local access database.
Created DTS package to export and import data from SQL Server to Access, text files and Excel files.
Set up backup using Veritas, checking event viewer on Windows Server 2000/03 and developed recovery procedures.
Proficient in Windows Server 2003, Windows XP, Linux, OS2 operating systems
Knowledgeable in Microsoft Exchange, MS SQL, MySQL, IIS, VPN, RAS, FTP Servers
Active Directory administration, user logon scripts
Security administration over web servers, mail servers using SSL sockets, firewall
Created DTS packages for migration of data from SQL Server to MS Access or Oracle databases.
Created automatically running stored procedures for day-end operation using SQL Server agent.
Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
Created and supported complex database schemas
Designed data models
Implemented Microsoft SQL 2005 Server in a test environment.
Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
Environment:Windows 2003 server, oracle 10g, 11g, RHEL, HP-Ux, ASP 3.0, PHP2, XML, MS SQL Server 2000 (Enterprise Manager, Query Analyzer), TSQL, Erwin 4.0.
Contact this candidate