Hello Recruiter, Please find Synopsis of our ORACLE DBA below. Please do let me know if you have any new position open for him at your end.
*Thanks,* *Jinal Shah* 1125 US Highway 22, Ste 1 Bridgewater, NJ 08807 Tel: 908-429-8008 x 347 Cell: 908-875-9179 Fax: 908-429-8005 Email: *[email protected]* ** * ****************************************************************************** * ** *SYNOPSIS OF OUR ORACLE DBA* ** *SUMMARY OF QUALIFICATIONS:* · Fourteen+ years of IT experience in various industries that support Service, Production & Information Technology. · Ten+ years of experience as Oracle DBA Including work of Database Management, Backup & Recovery, Performance Tuning, Configuration of Database, Tablespace administration, User management, Index management and managing data dictionary objects. · Extensive experience in installations of Oracle Software, Configuration for database and day to day routine works for database administration, System User administration, Index organization, Cluster creation. V$Views checking for daily performance Tuning of database. · Experience with Installation of SQL Server 2k or 2k5 or 2k8 in cluster and non-cluster environment as per company policy and maintaining documents for configuration. · Hands-on experience in RDBMS (Oracle 8, 9, 10g, MS Access, MS SQL Server 6.5/7.0/2000, 2005, 2008). · Experience with Oracle Enterprise Manager (OEM) for configuration and monitoring multiple instances. · Experience in Data Migration from SQL Server2005 to Oracle10g, SQL Server2005 to SQL Server2008. · Experience in writing Shell Script in VI Editor, Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes. · Fine-Tuned and optimized SQL queries and performed code debugging using TOAD, SQL Profiler. · Worked on Database size up to 4TB. *CERTIFICATION:* * * · Oracle8 Certified Professional (OCP) Certificate from Oracle Corporation: Database Administration, Backup and Recovery, Network Administration. · Oracle8 DBA Certificate from Brain Bench. · Master Diploma in Software Engineering *Technical Skills:* * * Database: Oracle (versions 7.3, 8.0, 8i, 9i, 10g, 11g), Microsoft Access, SQL Server 2k, 2k5, 2k8. Software: Developer 2000 (2.1) (Oracle Forms 3.0, 4.5, 5.0, Reports 1.1, 2.5, 3.0), Pro*C 1.5, 2.2, Visual Basic 5.0. SAP: SAP R/3 Basis Administration in V 3.x, 4.x, NW, BW. Languages: C, C++, SQL, PL/SQL, Basic, and COBOL. Networks: TCP/IP, MS Windows NT, MS Cluster. ** ** ** ** ** ** ** ** *PROFESSIONAL EXPERIENCE:* * * *Aug ’11 – Present Citi Group* *Sr. Oracle DBA Warren, NJ* * * *Responsibilities:* - Installation of Oracle 11.2 on Standalone and Cluster environment with *DMA(Database Middleware Automation)*. Create workflow for User Creation, Role & Profile Assignment for database users in DMA in Linux and AIX environment. - Successfully implemented workflow for Database backup & Recovery on Archive and non-archive database using RMAN and Data Pump export and Import. - Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server. - Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager. - Create Patching workflow for DMA to apply on standalone and cluster environment. - Apply Oracle-supplied patches to production and non-production databases for Linux and AIX environment to keeping all databases with up to date patch level. - Install DMA services on servers and configure with DMA environment for creating new workflow and installed HP workflows for Database automation. - Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy. - Working with 11g XML Database configuration, storage model, DB repository and creating XML Indexes for better performance. - Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local. - Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job. *Environment:* Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003. * * * * *Aug ’08 – Aug ‘11 SPX Corporation* *Sr. Oracle & SQL DBA Charlotte, NC* * * *Responsibilities:* - Installation of Oracle and SQL Server software with cluster (RAC) and non-cluster environment. Configuration of Database, User Creation, Role & Profile Assignment in SAP and Non-SAP environment. - Database backup & Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import. - Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and *Lite Speed* for SQL Server. - Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager. - Work on Disaster Recovery Project (high availability) and successfully configured Oracle and SQL production database. - Configure and manage Data warehouse system on Baan Application environment. - Perform Daily check for all SAP System with Global SOLMAN and working with BRTOOLs for database maintenance. (Daily checks Using Tcodes ST04, DB02, DB13, DB12, SM20, SM21, SM35, BD87, SM37, ST22 etc.) And perform Oracle and SQL database according to company policy. - DBA support on 24X7 environment, Supporting Central Administration Service Desk for Database related issue and work on Ticket to resolve the identified issues. - Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy. - Apply Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level. - Working with Database Refresh, Migration from Oracle 7 to 9i and Datacenter Move from one location to another. - Domain migration for Database servers. - Hands on work experience with *11g new features* like High availability, RMAN archive log management for streams and data guard, optimize undo backup, Data Pump to use for compression and encryption of backup, transportable partitions, Manageability with memory_target parameter for auto memory management, auto SQL turning, and more. - Knowledge of 11g new features of ASM like SYSASM role, Fast Disk Resync. - Work with installation and configuration of *Business Intelligence Publisher* (BIP-BI) with Oracle Application for reporting. - Work on OID configuration for Oracle 9i. - Work on configuration of *Oracle Golden Gate* 10.4 with Unidirectional for reporting. - Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local. - Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job. *Environment:* Oracle 9i, 10g, 11g, SQL Server 2k, 2k5, 2k8, SAP NW, SAP R/3, BI, XI, Vertex, Oracle E-Business Apps, Oracle Golden Gate, Linux, IBM Unix, SUSE, HP-Unix, Windows Server 2003. -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/us_itgroups?hl=en.
