More Related Content
What's hot (20)
Viewers also liked (19)
Similar to nadeem-cv-jun2016 (20)
nadeem-cv-jun2016
- 1. MOHAMMED NADEEM ULLAH KHAN Mobile: 0572945869 E-Mail: nadeemkhan.dba4all@gmail.com Address: Riyadh, K.S.A. CAREER OBJECTIVE To associate with an organization which progresses dynamically and obtain a challenging position wherein I would be able to implement my skills in an effective manner, meet challenges and also enhance my skills thus contributing continuously towards the growth of Organization. PROFILE HIGHLIGHTS EDUCATION B.E. (Information Technology), from Muffakham Jah College of Engineering and Technology, Osmania University (2009) with First Class (65.81%) CERTIFICATIONS & TRAININGS Oracle Certified Professional (OCP) in Oracle 11g Database Administration. Trained well in SQL scripting & basic PL/SQL and Linux Shell Scripting. Trained in Basic Network Administration and Troubleshooting. TECHNICAL SKILLS RDBMS Oracle 10g and 11g. Operating System Red Hat Linux, AIX, Oracle enterprise Linux 4, Windows XP, Windows 7 and Windows Server 2003/2008. Languages SQL, PL/SQL & Basic Shell Scripting. Database Tools Toad, Sql * plus , SQL developer, Oracle Enterprise Manager(OEM) Database Control and Grid control, Telnet, Putty, VNC Server, VMware Workstation, RMAN, SQL LOADER, TKPROF, AWR, ADDM, SQL Loader, DBCA, DBUA, NETMGR & NETCA and other tools. Other Skills Ms-Office Suite (Word, PowerPoint, Excel ,Access and Outlook), Hardware Troubleshooting & Network Configurations. PROFESSIONAL SUMMARY 4.6 Years of Experience as Oracle DBA supporting various Operational Application Systems and BI Systems for Multi service client ensuring integrity and availability of applications and databases to end users. 1.11 Years of Experience as SQL Analyst giving L1 DBA support to Oracle and SQL server Databases for Business Intelligence Application. Experience in Oracle 10g/11g Database Administration under multi-platform environments, including installation and configuration of software, maintenance, disaster recovery management. Experience in Database Creation/Maintenance (database instances), managing logical and physical database structures (Table, Views and indexes) as per Business requirement in coordination with relevant Business Functions. Provide required support to other IT functions and end- use support concerning application/database issues. Good experience in designing and implementing Backup & Recovery policies, Configuring and maintaining RMAN Backup Management. Experience with Oracle 11g RAC installation, maintenance and support. Implemented and maintained physical standby databases (Data Guard). Having good experience with the utilities like Data pump (Expdp & Impdp) and traditional export/import, SQL Loader and support for Informatica Workflow jobs. Experienced in SQL Server Database basic Administration. Knowledge of Mysql database administration. Database User & Access Management ensuring compliance with IT security policies and requirements. Implemented documentation of General Operating Procedures, Troubleshooting Guides, various operational tips and procedures. Analytical and able to adapt to new environments and learn new technologies quickly.
- 2. EXPERIENCE DETAILS Recent Projects : Oracle Database support for various Operational Application systems and BI Systems. Duration : June 2011 to Dec 2015. Employer : Phore Technologies, Hyderabad. Client : Verizon, U.S.A. About Client : Verizon is a wireless telecommunications and data service provider in the United States providing various products and services. Role : Oracle DBA. Environments : Oracle 11g, RAC and Data Guard on Red hat 5 and OEL 6, Oracle 10g Application Server for Legacy Operational Systems. Responsibilities : Availability to 24x7 on-call support on rotation basis for Production, UAT and Test Operational and BI systems. Pro-Active Database health monitoring using trace files and alert logs of all RAC instances, Cluster ware and troubleshooting related issues. Handling database related Escalations and coordinating with Application teams resolving issues. Part of Team involved in implementing RAC and database upgrade from 11.2.0.2 to 11.2.0.4. Migrating non ASM standalone databases to RAC and supporting post migration data issues. Monitoring OC4J instances and coordinating with Application Team resolving issues. Involved in installation of Data guard standby databases and disaster recovery testing for Production systems. Installation, Database Creation and maintenance of other stand alone legacy applications databases. Monitoring server and database performance and coordinating in tuning activities analyzing areas of performance improvement for issues related to Reports execution. Responsible for Deploying war files and database changes based on Script provided by developers. Performing Scheduled backup monitoring, implementing Backup and Recovery testing for Oracle database using RMAN and DATAPUMP utilities as per defined SLA policies. Involved in improving of Backup Methodologies and Recovery testing process. Replicating Production Issues on Development and UAT instances and resolving them. Managing Database Structure, Table/Index segments, Database User Access, Roles and Privileges. Monitoring & managing data files growth related activities involved in Table space Management and Capacity Planning for both ASM and non-ASM databases. Monitoring locks and User sessions and resolving Database hangs and blocking issue. Resolving Request Fulfillment Tickets related to Data validations, query modifications and access issues from various teams and ensuring resolution within defined SLA Agreement. Cloning production databases for UAT and QA testing for Operational Systems and refreshing as per requirement from Development Team. Monitoring and Scheduling DBMS jobs as per developers requirement. Creating database objects (tables, views, indexes, synonyms) once application developers have designed application and rebuilding the indexes and Gather statistics of tables to improve the performance as per requirement. Troubleshooting issues related to database connectivity (TNS, LISTENER issues). Root Cause analysis for RAC Instances and Database failures and Oracle Internal Errors resolution. Patching Using OPatch based on requirement. Organizing team meeting and co-ordinate with other team leads. Upgrading Skills based on Project requirements Creating Technical Notes and Documentation of all the activities. Raising SR and Coordinating with Oracle Corporation for support.
- 3. Previous Project : Database support for BI Application. Duration : June 2009 to May 2011. Employer : DataBot Systems Pvt. Ltd, Hyderabad. Client : ADP, U.S.A. About Client : ADP provides comprehensive payroll services and human resources management solutions for businesses of all sizes. Role : SQL Analyst. Environments : Oracle 10g (Red hat 5) & SQL Server 2008 (Windows). Responsibilities: Alert Monitoring (Email alerts & Tool alerts), Reporting and Escalations of various scheduled jobs like Cron Jobs, Informatica work flow jobs, Sql server jobs and Performing Basic Level 1 Troubleshooting. Effectively used platform-specific, as well as enterprise, monitoring tools to provide fault and pre- fault performance and Job failure notifications. Act as first point of contact for customers reaching out for support for applications within the business environment. Created and modified tables, views and indexes, PL/SQL stored procedures, functions and triggers according to business requirement. Imported and Exported data from different sources using Customized Client Tools. Experience in loading data using Oracle SQL Loader. Granted and revoked privileges to users. Monitoring Blocking sessions and coordinating with L2 team killing idle sessions Supporting SQL server data Replications. Worked with development team investigating and correcting software bugs and deficiencies based on the testing result. Creating SQL Server and Oracle Databases and Users as per L3 Requirements on Test/UAT. Performing backups of various databases as per request and approval of L3 team. Running Predefined Linux Shell Scripts on Oracle Databases and SQL server scripts on Windows server 2008 as per requirement and approval from L3 team. Escalate the incidents to L2/L3 if not solved within defined SLA. Documented the problems and solution in the failures of production databases. Participating in weekly meeting with Managers and Project Leads to discuss issues and progress of ongoing projects and Process Improvement programs. PERSONAL DETAILS Date of birth : 19-April-1988. Languages known : English, Hindi, and Urdu. Nationality : Indian. Current Residence : Riyadh, K.S.A Marital status : Married Dependents : 2 Passport No : H1306915 (valid till 10/2018). Iqama Status : Transferable. I hereby declare that the information furnished above is authentic to the best of my knowledge and belief. Place: Hyderabad. (Mohammed Nadeem ullah khan)