Database Administrator Resume
Plano, TX
OBJECTIVE
- 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.
- Seeking a professional position in the IT field where I can contribute to company success and growth while increasing my knowledge and experience.
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, Oracle 9i, Oracle 8i, E-Business Suite 11i
Software Applications: MS Office Suite, Remedy Version 7.0, Adobe, Flash, Toad
PROFESSIONAL EXPERIENCE
Confidential, Plano, TX
Database 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, 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.)
- Responsible for creating and testing backup plans for all databases SQL Server (Database maintenance plans) and Oracle (RMAN 9i,10g and OEM)
- Setup monitoring for the SQL Server (NetIQ) and Oracle environments (BMC Confidential )
- 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 Adminstrator
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 software creating 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)
Confidential, Plano, TX
Database 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 Confidential )
- Writing database documentation, including data standards, and procedures
- Working closely with IT project managers, database programmers and application developers to effectively maintain the environments.
Confidential, Addison, TX
Systems Administrator
Responsibilities:
- Monitored all of Confidential online applications and servers via Confidential
- Recognized critical issues, resolved critical issues and escalated non - resolved issues to the correct support groups
- 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
Confidential, Plano, TX
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 Confidential .
- I was also responsible for completing daily scheduled tasks. I also worked with Citrix, supporting the servers
Confidential, Southlake, TX
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.
Confidential, Bedford, TX
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
Confidential, Dallas, TX
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.
Confidential, Addison, TX
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