Oracle\sql Dba Resume
Allen, TX
SUMMARY:
- Innovative, versatile and results - oriented IT professional skilled in all aspects of database management support and strategic integrated interaction planning and execution.
- Analytical, detail-oriented, problem-solving team player with a commitment to excellence in all ventures.
- Self-starter with exceptional capacity to organize and manage multiple tasks, often with completing priorities while consistently maintaining a high level of quality output and meeting deadlines.
- I am seeking a professional position in management where I can contribute to company success by delivering services that are essential to the business need and my personal growth.
TECHNICAL SKILLS:
Operating Systems: Red Hat Enterprise Linux 5, HP-UX 11, AIX 5.0, Solaris, Windows (XP, 2000), Windows Server 2003, Vmware Workstation 5.0, Apache Server, Oracle Virtual Box
Programming languages: C, C++, UNIX, Php, Visual Basic.Net, T-SQL
Relational Databases: MySQL, MSSQL Server 2000, MSSQL Server 2005, MSSQL Server 2008, Oracle11g, Oracle 10g and Oracle 10g RAC, Oracle 9i, Oracle 8i, E-Business Suite 11i
Software Applications: MS Office Suite, Remedy Version 7.0, Adobe, Flash, Toad
PROFESSIONAL EXPERIENCE:
Confidential
Oracle\SQL DBA
Responsibilities:
- Responsible for sql server 2008 R2 installations for 20-30 servers
- Creation of multiple databases for different platforms SQL\ORACLE
- Responsible for Oracle 10g installation for Unix and windows platforms for 10 servers
- Installed and configure oracle grid control for database environment
- Setup replication and mirroring for sql server environments
- Handled 5 client transitions for ATOS Origin for physical and logical support (knowledge transfer from client in regards to the current state of the environment, hardware and software, information gathering, critical best practices, exceptions logging, monitoring setup, updates to the environment and steady state support)
- Maintenance of the environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly
- Writing database documentation, including data standards, and procedures
- Practicing ITIL methods for incident, request, problem and change management.
Oracle DBA
Responsibilities:
- Involved in large migration of 250 Oracle databases 9i,10g, and 11g
- Involved with project planning for specific tasks for completion
- Installation of Oracle software platforms including Oracle database 11g
- Installed and configure oracle grid control for database environment
- Creation of multiple databases for different applications
- Configure backups for databases with rman, export, and also EMC Networker
- Setup Patrol monitoring for database environments
- Steady state support for databases and applications
- Documenting steps and procedures for database tasks
- Following ITIL’s best practices for incident, request, problem and change management
Database Administrator
Responsibilities:
- Handled numerous clients transitioning into the Dell model for physical and logical support (knowledge transfer from client in regards to the current state of the environment, hardware and software, information gathering, critical best practices, exceptions logging, monitoring setup, updates to the environment and steady state support)
- Responsible for over 400 SQL Server (2000, 2005, 2008) and 50 Oracle environments
- Installation of SQL Server Versions and Oracle 10g for new environments on Windows Server 2003 and AIX 5.0, HPUX 11, Red Hat Enterprise Linux 5
- Experience with configuring RMAN backup\recovery and executing Data Pump export and import methods
- Configured Oracle Enterprise Manager and Grid Control for online database administration (user security privileges, tablespaces, objects, etc.)
- Supporting High Availability Methods Oracle Clusterware and RAC 10g,11g on multiple nodes including managing ASM instances as well
- Responsible for creating and testing backup plans for all databases SQL Server (Database maintenance plans) and Oracle (RMAN 9i,10g and OEM)
- Installation and configuration for monitoring for the SQL Server (NetIQ) which included adding alerts for baselines, setting thresholds and schedules and actively monitoring activity for NetIQ, responsible for troubleshooting and restoring incidents reported through NetIQ
- Maintenance of the environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly
- Writing database documentation, including data standards, and procedures
- Working closely with IT project managers, database programmers and application developers to effectively maintain the environments. Assisting with developing and supporting the applications and providing daily 24x7 on - call support for environments
Database Administrator
Responsibilities:
- Responsible for over 150 SQL Server (2000 and 2005) and 6 oracle database environments and 1 oracle apps environment
- Responsible for cloning and patching (prod, test, dev for oracle 10g and prod, test, dev for datawarehouse)
- Implemented log shipping for Get Paid application
- Installation of SQL Server Versions and Oracle 10g for new environments on Windows Server 2003 and Red Hat Enterprise Linux 5
- Involved in migrating Oracle environment from Oracle On Demand to In-house support
- Responsible for consolidating SQL Server environments from old hardware to new hardware by moving databases from server to server
- Develop stored procedures for Buy Design online window ordering system using triggers (insert, update, delete) Cursors, etc.
- Worked closely with Buy Design vendor for implementation of application and softwarecreating linked servers with OLEDB for prod, test, and dev
- Responsible for creating and testing backup plans for all databases SQL Server (Database maintenance plans) and Oracle (RMAN 10g)Maintenance of the environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly
Confidential, Addison, Tx
Systems Administrator
Responsibilities:
- Responsible for over 400 SQL Server (2000 and 2005) and 50 Oracle environments
- Installation of SQL Server Versions and Oracle 10g for new environments on Windows Server 2003 and AIX 5.0, HPUX 11
- Experience with configuring RMAN backup\recovery and executing Data Pump export and import methods
- Configured Oracle Enterprise Manager and Grid Control for online database administration (user security privileges, tablespaces, objects, etc.)
- Responsible for creating and testing backup plans for all databases SQL Server (Database maintenance plans) and Oracle (RMAN 9i and 10g)
- Setup monitoring for the SQL Server (NetIQ) and Oracle environments (BMC Patrol)
- Maintenance of the environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly
- Writing database documentation, including data standards, and procedures
- Working closely with IT project managers, database programmers and application developers to effectively maintain the environments.
- Traveled to Newark, DE for extensive training to learn Legacy MBNA procedures for system administrators
- Monitored all of Confidential online applications and servers via PATROL
- Recognized critical issues, resolved critical issues and escalated non - resolved issues to the correct support groups
- Installed and configured UNIX OS such as RedHat and Oracle Enterprise Server
- Responsible for security and filesystem management within the OS (AIX,Solaris) using SAM-system administrator manager
- Responsible for weekly maintenance on production/development servers including backups and rebooting
- Also monitored Confidential production and development servers via Tivoli Business System Management, Formula and Tivoli Enterprise Portal
- Responsible for daily reporting for shift turnover and quarterly releases using Crystal Reports version 10
Desktop Analyst
Responsibilities:
- Responsible for support on various accounts
- Experience with Crystal Reports Version 10 for writing reports involving business data
- Experience with planning, designing and developing reports for clients
- Importing and exporting data from different databases and submitting queries for specific business data.
- Experience with SQL Server 2000 using T - SQL(enterprise manager, query analyzer, table/data navigation and manipulation)
- SQL server replication (publisher, distributor, subscriber)
- Installation and configuration of SQL Server 2000
- Some database administration including maintenance plans, backups, updates, and analyzing data
- Interface directly with clients and users
- Update system server with new versions of relevant applications
- Helping clients troubleshoot problems on desktops, laptops and servers
- Assisted clients with setup of applications, servers, networks, etc
- Assisted network security and system administrator with access for different client accounts, Active directory, rebooting and monitoring servers, using remote desktop troubleshooting windows problems for clients
- Experience with developing training guides and SOP documentation for clients
- Worked with OPAS/Remedy ticketing system to address problems and issues. Helped coordinate UNIX and Intel with our extended team in Romania and Tier 2 engineers from Perot Systems. I was also responsible for completing daily scheduled tasks. I also worked with Citrix, supporting the servers
Account Manager
Responsibilities:
- Worked for a delivery driving mail distribution company
- Specialized in interaction and building relationships with the customers
- Responsible for providing prompt and sufficient service for our products including documentation such as writing reports and invoices for services
- Worked with Crystal Reports version 10 (planning, designing, and developing reports) and customizing reports to meet specific requirements
- Responsible for creation and modifying of reports including formatting and manipulation of records (summaries, charts, sorting, grouping, and visual elements)
- Presented and distributed reports to clients, importing and exporting data in different formats (HTML, WORD, PDF, EXCEL, RPT) upon requests
- Also used reporting to extract data for monthly reviews involving profit and goals for the company
- Created formulas in the formula workshop for given scenarios
- Installation and configuration of SQL Server 2000
- Creation of databases and tables to keep track of client information.
Help Desk
Responsibilities:
- Problem solving for irate customers, technical support for products including troubleshooting software, hardware, etc.
- Explaining our products and services to perspective customers and providing warranty and maintenance details to customers
Data Analyst
Responsibilities:
- Setting up new accounts, collections
- Providing billing information, processing claims, and administrative support
- Problem solving and technical support for customers including personal computers, notebooks, printers, etc.
Key Operator
Responsibilities:
- Managed employees for third shift
- Responsible for placing multiple project orders
- Selling products to customers and follow - up with customers
- Setting up new accounts, assisted customers in computer services, cashiering, balancing cash drawers, updating daily inventory