Sr Developer/DBA
Resume:
MD KAMRUL HASSAN
**********@*****.***
Objective
To secure a position in an Oracle DBA that utilizes my over 8 years of experience and education
Summary
•Oracle Database Administration on various operating systems such as Linux, Sun Solaris, AIX and MS SQL Server 2005/2008 on Windows 2003/2008 Server
•In depth knowledge and extensive working experience in Oracle database administration such as data modeling, database design, performance tuning, system set up and upgrade, backup and recovery
•Excellent understanding of Oracle architecture and Oracle tunable parameters
•Excellent understanding of Oracle RDBMS 9i through 11g and Oracle data dictionary
•Hands on experience in Oracle advanced technologies such as 10g RAC, OEM, Grid Control, Data Guard (both logical and physical), partitioning, RMAN
•Implemented a standby database operation using Oracle9i, 10g Data Guard for data loss and also provides graceful switchover and switchback between sites for a planned OS and hardware maintenance
•High-volume production database support, Oracle Fail Safe implementation (Data Guard), backup plans and implementation, Performance monitoring and tuning (Statspack)
•Experience in implementing and using of Oracle 10g new features like Data Pump, ASM, Flash Back Technology, Transportable Tablespaces and Automatic Workload Repository
•Planning and scheduling Physical Backups using RMAN and Manual methods and Logical Backups (Full, User, Table)
•Oracle Installation, upgrade and migration (9i ,10g and 11g )
•Developed Unix Shell scripts to automate database operation and monitoring
•Expertise in security, monitoring activity, installation, backup and restores, recovery, tuning , SQL and PL/SQL
•Experience in working as SQL Server DBA as well as SQL Server Integration Package
•Experience in SQL Server Backup/Recovery, Database Administration and Performance Tuning
Technical Skills
Operating Systems:Windows XP/7, Windows Server 2003/2008, Linux, Sun Solaris, AIX,DOS
RDBMS: SQL Server 2005/2008, 0racle 9i/10g/11g, Raiser’s Edge
Languages:C language, C#.NET, VI Editor, PL/SQL, UNIX Shell Scripting
Tools & Utilities:Oracle’s OEM, Data Guard, SQL Loader, SQL analyze RMAN, EXP/IMP, EXPDP/IMPDP
Application Tuning:AWR, SQL Trace, TKPROF, Explain plan, Wait Events and Statspack
Networking:FTP, TCP/IP, Telnet, LAN/WAN, Routers/Switches, Hubs, VoIP, VPN, Desktop Sharing, Active Directory
Other: MS-Office suite
Work Experience
Avotel Communication, Westbury, NY Oct 2008 - Present
Oracle DBA
Avotel Commucation provides customers easy access to view their billing reports, account status, pay bill and online customer support. Their products are VoIP related like voice termination, generation, IP phone etc. Also daily system monitoring and troubleshooting, installation of software upgrades
Responsibilities:
•Responsible for the physical design, implementation and maintenance of Oracle
•Work closely with the DBA group and project managers to translate logical data models into and effective physical database
•Implementation security and integrity rules, performance monitoring and tuning, backup and restore
•Providing technical education, and assisting problem identification and resolution
•Develop SQL Server Integration package for Backup the Subsystems
•Develop SQLLDR Programs to Load the data in different Database system
•Develop PL/SQL program to create Database Administration Job
•Maintain and updated electronic records and databases consisting of billing; vendor, agent, and customer information
•Responsible for importing and exporting data to/from the oracle system
•Monitoring Backup and Recovery related issues and rerunning the failed backups in RMAN
•Perform SQL tuning
•Maintain Oracle schemas and SGA region
•Manage Users, Privileges and Roles
Environment: Linux , Oracle 10g/11g, MS SQL Server 2005, RMAN, SQLLDR, PL/SQL, MS Office 2007, Windows Server 2003/2008, Windows 7/XP
Sun Trust Bank, Arlington, VA Dec 2007-Sept 2008
Oracle Programmer/Analyst
Maintain and administer more than 500 Oracle DBMS nationwide Sun Trust Bank branches. Handles multiple projects including migration database and data management through the various stages of the development life cycle
Responsibilities:
•Extensively involved in writing PL/SQL stored procedure/functions and triggers
•Create UNIX batch files (Shell Script) to process name & address parsing
•Partial Backups of all data files for individual tablespace daily and full backups weekly
•Created/Modified Table/Index Structures using SQL*PLUS and calculate space requirement for the table and index
•Load foreign data into an Oracle database using Export, Import, and SQLLDR
•Performed tuning and optimize an Oracle database environment on different levels: data structures, SQL statements, PL/SQL
•Solid experience in managing Oracle in High Availability environments using Parallel Server, Failovers, and Cloning technologies
•Monitoring the export backups and initiating client requested exports and imports
•Managed of MS SQL Server including backups, restores, monitoring
•Managed tablespaces, data file, redo logs, tables and its segments
Environment: Sun Solaris, Oracle 10g, MS SQL Server 2005, SQLLDR, SQL*PLUS, Shell Script, RAC, Data Guard, Windows XP
New York City College of Technology, Brooklyn, NY Dec 2006-Nov 2007
DBA Manager
City Tech Maintain, administer and upgrade the college students’ information using Oracle, SQL Server, Raiser’s Edge .Generated queries, export/import data, produced lists and reports in response to departmental and administrative needs
Responsibilities:
•Resolved any oracle daily issues and / or problems
•Added, changed, and removed users
•Assigned users appropriate rights and table access through roles
•Monitored the system for runaway oracle process
•Added, changed, removed tables and tablespace depending on the applications requirements
•Monitored tables and tablespaces for extents, row-chaining and size-perform
•Researched upgrade version to determine if they would affect applications
•Setup and documented Data Guard Fail-Over/Switch-Over/Read-Only scenarios in RAC
•Reviewed and tuned SQL queries, stored procedures, views, triggers
•Analyzed and optimized MS SQL Server production databases
•Performed Windows Server and UNIX system administrator tasks as part of maintenance
•Created or clone the Oracle Instance and Database on ASM. Perform database cloning and re-location activities
Environment: Sun Solaris, Linux, Windows Server 2003, ASM, PL/SQL, Blackbaud Raiser’s Edge
FTF Inc. New York, NY Oct 2004 – Nov 2006
Database Administrator
Responsibilities:
•Creation of ORACLE databases
•Standardization of ORACLE database environments
•Database planning and design of logical storage structures and capacity planning for
future growth
•Developed and administer processes for capacity planning
•Configuration and setup of OEM monitor production databases
•Designed, deployment, monitoring and troubleshooting of rollback segments
•Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups,
Data Pump tools
•Documented policies and procedures for each project including recovery in case of
disaster using procedures, such as daily script creation of control files and copying
binary control files to backup directories, database copying, and renaming a database
on different servers
•Migration of data from the Production to Test/Dev databases as per the requirement
of the Development team and restoring the data if it is corrupted
Environment: Linux, Oracle 9i, OEM, SQL*PLUS, MS Office, QTP, Hot/Cold Backup
Developer/Oracle DBA Mar 2003- Sept 2004
Walmart, Secaucus, NJ
Responsibilities:
•Installation and upgrade of the DBMS and associated utilities and software
•Ensure data on mirrored oracle servers is replicated and point-in-time recovery
•Database and server security and control (Roles, Grants, Network access, etc.)
•Rollouts of all systems / new applications follow standards and naming conventions
•Design and implementation of physical databases and tables with constraints
•Tablespace and data file space management
•Developed, documention, and tested database installation procedures
•Identification and implementation of performance and resource utilization metrics
•Database and application performance monitoring and tuning
•Troubleshooting and resolution of DBMS and application problems
•Effective interface with network support team and application development teams
•Train and share technical expertise and experience with team members
•Created tables and indexes
•Troubleshoot and repair desktop computers
Environment: Sun Solaris, Oracle, SQL Server, MS Office
Education
Master of Science in Computer and Information Systems
Brooklyn College (The City University of the New York), Brooklyn, NY
Statistics: Status: U.S. Citizen
Contact this candidate