- TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.
- Languages :
- SQL, PL/SQL, UNIX Shell Scripting, PERL, T-SQL.
- Tools and Utilities:
- RMAN, OEM, SQL
- Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer, SQL Server Integration Services SSIS, SQL Server Management Studio, Microsoft Team Foundation Server .
- RDBMS :
- Oracle 9i, 10g, 11g, 12c, 19c, MS SQL Server 2012
- Operating Systems :
- HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1, 7.0, RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000/2007, Windows Server 2008 R2 Enterprise.
- SKILLS SUMMARY
- Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
- Worked on Data transferring with export/import utilities and Data pump.
- Experienced in performance monitoring/tuning/troubleshooting.
- Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
- Implemented automated backup strategy with the UNIX shell script and CRON UTILITY for performing Cold Backup and RMAN incremental backups.
- Experience in performance tuning using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Explain Plan, SQL TRACE, STATSPACK and different OEM utilities.
- Strong working knowledge of development tools like TOAD, SQL Developer.
- Proficiency with utilities such as Data Pump, SQL
- Loader and TFS.
|
- Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
- Experience with RMAN Backups, Hot Backups and Logical Backups.
- Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
- Skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “run Installer” and Perl based utility “Opatch”.
- Experience in doing upgrades including maintenance & monitoring implementation.
- Experience in monitoring and performing routine database tasks.
- Basic Experience in MS SQL Server 2012
- Basic Experience in Windows Server 2008 R2 Enterprise.
- Basic Experience in T-SQL and SQL 2012 SSIS packages
- Experience in Microsoft Office 2013 (Word, Excel, Outlook)
- Experience in Microsoft Team Foundation Server (TFS)
- Ability to communicate effectively with a multiple audience
- AIX/UNIX Systems Administration - Database and application integration efforts.
- GO LIVE, Capacity planning, Disaster recovery, Excel, 98, Oracle 9, ORACLE/SQL, RDBMS, Sound, Troubleshooting, Utilities
- AIX, Change management, HP-UX, Microsoft Office, NT, Oracle, Oracle SQL, Red Hat Linux, MS SQL Server, Type, VM
- AIX 5.1, CPU, IDs, Outlook, Word, DBA, Peak, Servers, SQL, UNIX Systems Administration, VMS
- Backup, Client, Linux, Windows, Migration, Db, PERL, Scripts, SQL Server, UNIX Shell Scripting
- Basic, DATABASE, Managing, 2000, Enterprise, Oracle Database, Policies, Script, Strategy, UNIX shell
- Bind, Databases, Meetings, 3.x, OS, Developer, Progress, Sun Solaris 2.5, TOAD, Upgrades
- C, Designing, Access, Windows 95, Operating Systems, PL/SQL, Quality, Sun Solaris, T-SQL, Upgrade
|