Top Database Administrator Skills

Below we've compiled a list of the most important skills for a Database Administrator. We ranked the top skills based on the percentage of Database Administrator resumes they appeared on. For example, 18.2% of Database Administrator resumes contained Database as a skill. Let's find out what skills a Database Administrator actually needs in order to be successful in the workplace.

The six most common skills found on Database Administrator resumes in 2020. Read below to see the full list.

1. Database

high Demand
Here's how Database is used in Database Administrator jobs:
  • Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
  • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
  • Provided reporting, user support, managed access groups, and user addition/deletion related to database management systems.
  • Handled database management activities, maintained activity reports and communicated with state inspectors on a daily basis.
  • Researched database and performed queries to obtain specific employee-related data for various internal departments.
  • Implemented and Troubleshooted log shipping and database mirroring for high availability of critical databases.
  • Update database with current/new/transferring property management, In addition to generating new accounts.
  • Plan and implement database maintenance plan for ensuring database reliability and integrity.
  • Created and maintained contingency plans and established the database security procedures.
  • Manage initial and updated database deployments to cloud-based and/or internal environments.
  • Provided recommendations for database fail-over and recovery at emergency backup site.
  • Generated and maintained scheduling of prompt data loading into proprietary databases.
  • Designed databases for referential integrity and involved in logical design plan.
  • Performed database point in time database recovery at crucial database failures.
  • Created and implemented database design solutions in collaboration with programming team.
  • Performed routine DBA activities and administered the physical standby database.
  • Maintain company database with new information for future market research projects
  • Maintained database requirements pertinent to aircraft assigned to the mission.
  • Designed and Implemented database maintenance plans for various database activities.
  • Implement 24/7 monitoring solution for various application services and database.

Show More

2. Pl/Sql

high Demand
Here's how Pl/Sql is used in Database Administrator jobs:
  • Generated PL/SQL scripts for data manipulation and validation and created various Snapshots/ materialized views for remote instances.
  • Designed and developed data migrations using Oracle PL/SQL ensuring accuracy during system testing and reduced implementation time.
  • Supported internally developed corporate conferencing applications, in a core of PL/SQL with a PowerBuilder front-end.
  • Involved in designing new structures/procedures/views/functions/triggers for development and data migration from production to reports using PL/SQL.
  • Developed an end user interface and database management applications using PL/SQL.
  • Generated PL/SQL blocks proficiently using dynamic reference cursors.
  • Designed/developed and implemented archiving/purging schemes using PL/SQL packages.
  • Design was implemented with only 5 lines of PL/SQL code changed for performance reasons, and no changes to PowerBuilder code.
  • Work with different vendors and wrote Stored Procedures, Functions, and Packages using PL/SQL to implement business rules and processes.
  • Analyzed numerous PL/SQL defects and data quality issues report by the test teams and identified the root cause of the problem.
  • Created Stored Procedures to transform the data and worked extensively on SQL, PL/SQL for various needs of the transformations.
  • Experience in developing database applications using Oracle tools like SQL, PL/SQL, Forms and Reports in a client/server environment.
  • Use PL/SQL programming to create database integrity with primary keys, foreign keys, domain definition, and business rules.
  • Developed and maintained of PL/SQL stored procedures, triggers, database schema scripts, UNIX scripts and system documentation.
  • Organized a conversion effort of Oracle PL/SQL reporting queries to be used in the SQL Server T-SQL 2005 environment.
  • Developed UNIX and PL/SQL scripts to automate key database functions (online backups, database exports, etc.)
  • Developed custom packages using PL/SQL as well as data load scripts tested in-house programs, and optimizing services.
  • Developed and assisted developers to write SQL, PL/SQL, Stored Procedures, Views, Triggers and Functions.
  • Developed SQL & PL/SQL scripts to add, change & delete data from database on a regular basis.
  • Write, test, and modify systems and reports for staff and outside vendors using SQL and PL/SQL.

Show More

3. Recovery Procedures

high Demand
Here's how Recovery Procedures is used in Database Administrator jobs:
  • Implement backup and recovery procedures for ChaseCanada Data Warehousing and CommercialCards databases and test regularly in conjunction with Operations.
  • Enhanced database performance, performed restores, implemented recovery procedures, handled performance tuning and installed database applications updates.
  • Maintain familiarity with disaster recovery procedures and remain ready to participate in a disaster recovery in case of disaster.
  • Provided assistance in supporting daily operations to ensure availability and performance of system databases and testing disaster recovery procedures.
  • Developed backup and recovery procedures, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
  • Design and document database architecture to ensure storage, archiving, back-up and recovery procedures are functioning correctly.
  • Implement recovery procedures, performance tuning, database updates, troubleshooting and customization for over 10 production databases.
  • Design and Implement Backup & recovery procedures and ensure reliability of Database Backup and Recovery schemes.
  • Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
  • Designed and implemented backup and recovery procedures to have high availability of the databases and application.
  • Plan, implement and execute database backup and recovery procedures, including disaster recovery solutions.
  • Performed system maintenance tasks including file reorganizations, file and system modifications and recovery procedures.
  • Used database import/export and load utilities for various maintenance and logical backup and recovery procedures.
  • Created daily database backup and recovery procedures for Development, Testing and Production environments.
  • Ensured availability of data by monitoring systems and ensure compliance with disaster recovery procedures.
  • Implemented and documented recovery procedures, handled performance tuning and conducted regular system backups.
  • Implemented backup and recovery procedures; established disaster recovery and high availability plans.
  • Developed administrative tasks of SQL Server of performing daily backups and recovery procedures.
  • Implemented and performed backup and recovery procedures for application and reporting databases.
  • Developed backup and recovery procedures for development, testing and production servers.

Show More

4. SQL

high Demand
Here's how SQL is used in Database Administrator jobs:
  • Reviewed and approved stored procedures developed by the developers and data modification SQL script for production.
  • Manage and maintain multiple production SQL servers for online publication of medical documentation.
  • Implemented SQL analytic statistics model useful to query optimization and instance tuning.
  • Validated databases for correct configuration and SQL Server agent job completion.
  • Documented operational procedures; presented SQL seminars to end-users.
  • Generated reports utilizing SQL Server Reporting Services.
  • Performed corporate SQL Server inventory.
  • Developed and implement MySql database.
  • Migrated the database from 8i (8.1.7) to 9i (9.1) Analyzed and optimized MS SQL Server production databases.
  • Consulted with various SQL Server and non-SQL Server customers in and outside Fidelity on application, reporting, and database design.
  • Monitored all activities of the server by monitoring the daily SQL jobs, SQL Server error logs and Windows event logs.
  • Use VBA and SQL programming skills to create and modify data entry/retrieval forms, queries, mailing lists, and reports.
  • Provided backup support for the Programming Team in the following Languages, HTML, Java, PHP, and MySQL.
  • Collected, analyzed, and organized highly sensitive and confidential patient medical data into reports using Crystal Reports and SQL.
  • Integrated old system data into new system application upgrades such is fixes, patches, Microsoft SQL and other updates.
  • Designed/implemented forms, GUI interfaces for querying and updating data from existing database in MS Access and SQL server 2005.
  • Enabled the CDC functionality in SQL server to track the data change and generate the Incremental extract for other team.
  • Designed and implemented the database to use more Stored Procedures instead of creating SQL statements in the various applications.
  • Upgraded SQL server 2000 boxes to SQL server 2005 and acted as the point of contact for all developers.
  • Put together an action plan to upgrade existing MSSQL servers to SQL 2012 and take advantage of AlwaysOn.

Show More

5. Customer Service

high Demand
Here's how Customer Service is used in Database Administrator jobs:
  • Executed daily operations of Marketing, Sales, Pharmacy Automation, Customer Service, Account Management, Electronic Medication Administration Records.
  • Determined best method to resolve complex customer service problems to ensure customer satisfaction and adherence to company policies.
  • Collaborate with internal departments to meet company goals of providing both quality products and excellent customer service.
  • Provided backup support to other team members, leveraging technical expertise in delivering excellent customer service.
  • Restructured Customer Service into groups including service activation, customer care and local service provisioning.
  • Served as the customer service representative to receive and disseminate information to appropriate parties.
  • Provided exceptional customer service while answering calls regarding various projects across the nation.
  • Provided customer service via email and phone including education and order issues resolution.
  • Improved customer service/satisfaction and service level agreement using full life cycle logistical solutions.
  • Designed and developed procedures to reconcile 3rd party customer service representatives charge backs.
  • Received extensive praise and recognition for exceptional customer service and dispute management.
  • Managed the team charged with implementing customer service into deregulated operator services.
  • Directed training teams, ensuring first-rate operations and customer service during openings.
  • Facilitate customer service inquiries, and provide technical support with timely solutions.
  • Provided customer service to support users and maintain 100% application availability.
  • Developed the employees and created a consistently excellent customer service experience.
  • Resolved customer service complaints in a professional and timely manner.
  • Recognized for providing exceptional customer service by management and users.
  • Provided customer service by answering phone inquiries regarding service requests.
  • Designed new procedures in both distribution and customer service departments.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Windows XP

high Demand
Here's how Windows XP is used in Database Administrator jobs:
  • Work daily with a calculator and a computer using Windows XP, QuickBooks Pro, Microsoft Office, etc.
  • Performed in house tech support including Windows XP, Vista, MS Office, Outlook, and Exchange.
  • Upgraded from windows XP to Windows 7 for 26 computers at stores level and 35 computers at offices.
  • Designed implemented and maintained Windows XP Advanced Server Beta 3/Windows XP Corp. Ed.
  • Experience working with Windows 2003, Windows XP and Windows 7 environments.
  • Network Administrator - maintain small Windows XP network, troubleshoot printer issues
  • Installed and configured MySQL on Windows XP, Windows Vista environment.
  • Managed the system with Windows XP and a proprietary database.
  • Administer Oracle database environment in a Windows XP and environment.
  • Support Oracle 10g on Windows XP Platform.
  • Configured and migrated the use of Medistem from Windows XP to Vista.
  • Project: COMLINE and AUTO Team: 14 Environment: Teradata V2R5, Windows XP, UNIX.

Show More

7. DBA

high Demand
Here's how DBA is used in Database Administrator jobs:
  • Provided constructive feedback, tools and guidance to franchisees focusing on overall improved operational and financial performance for each location.
  • Provide continuous DBA support of the system environments to ensure maximum database operational efficiency.
  • Worked independently as communication freelancer DBA Roy's Contracting and Technologies.
  • Maintain documentation in accordance with DBA operational policies and procedures.
  • Coordinated DBA support for highly utilized primarily mainframe reporting platform.
  • Created and maintained documentation for DBA standard operating procedures.
  • Gathered customer feedback and research solutions for system improvements.
  • Project Manager/Production DBA and System administrator.
  • Worked with DBA team to ensure implementation of the databases for the physical data models intended for the above data marts.
  • Coordinated multiple releases by working closely with various teams like UNIX, Storage, System DBA, Application and other teams.
  • Worked closely with the senior DBA to Database Backup, Recovery, Disaster Recovery, procedures, and SQL server clustering.
  • Assisted the primary DBA in various DBA activities such as Database Creation, performance tuning and also creating / maintaining snapshots.
  • Mentored DBA support to the Application Developer s in resolving the Oracle related issues while accessing Pro*C and Shell scripting.
  • Directed sales staff to actively communicate customer behavior, and give merchandise feedback, which allowed more effective merchandise buys.
  • Created a ABBOTT DBA Portal using Oracle Portal and the above mentioned systems can be launched from within this portal.
  • Interviewed, recruited, and trained new DBA group members to continuously improve processes and exceed expectations of customer base.
  • Lead DBA on 3 software and database production release implementations on US Air Force Space Command real-time SPADOC 4 system.
  • Provide production database support for the petroleum applications on daily DBA function in multiple Oracle instances environment for Oracle 8i/9i/10g.
  • Worked with Sr. DBA in designing and developing oracle database, created tables and views as per the specifications.
  • Worked in all phases of Information technology from EAM operator to DBA, this represents 28 years of experience.

Show More

8. High Availability

high Demand
Here's how High Availability is used in Database Administrator jobs:
  • Developed and tested storage strategies and disaster-recovery plan for operational database, delivering solution that guaranteed recovery performance and high availability.
  • Experience in implementing High availability solutions like different Replication, Log shipping, Clustering and Mirroring on physical and virtual machines.
  • Configured and administered disaster recovery solutions as well as high availability solutions such as Mirroring, Log Shipping and Clustering.
  • Performed system level database maintenance plans, performance tuning, backups, and database recovery in a high availability environment.
  • Implemented SQL Server high availability solutions including clustering, replication and log shipping Worked in Active/Passive and Active/Active cluster environment.
  • Implemented AlwaysON high availability with primary and secondary replicas in associated availability groups across multiple SQL Server cluster nodes.
  • Implemented disaster recovery solutions such as log shipping, replication, mirroring and clustering to ensure high availability.
  • Design, development and implementation of High availability, Database security, Disaster recovery and Database monitoring solutions.
  • Perform database backups, restores and develop high availability strategies using database mirroring, replication and log shipping.
  • Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
  • Implement High Availability/Disaster Recovery utilizing various methods, such as mirroring, peer-to-peer replication, and clustering.
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Implemented, designed and supported High Availability and Disaster Recovery processes and standards for mission critical systems.
  • Participated in design of high availability DBMS architectures Development, Test, Staging and Production database environments.
  • Migrated all the test environment objects into Production database and maintained high availability of the database.
  • Experience with implementing High Availability of databases servers using database mirroring, replication and log shipping.
  • Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose.
  • Developed implementation plan for configuration of High Availability (HA) solution for production environments.
  • Supported disaster recovery plan with high availability and fail-over capability using HP M/C Service Guard.
  • Installed, configured, and maintained database high availability solutions using Replication and Log Shipping.

Show More

9. Unix

high Demand
Here's how Unix is used in Database Administrator jobs:
  • Performed system integrate/quality assurance for the Prism Warehouse Manager products on various relational database and UNIX platforms.
  • Prepared complex UNIX scripts to support applications and database administration functions.
  • Provided technical support for application developers and Unix administrators.
  • Automated database administration tasks using UNIX shell scripting.
  • Provided the UNIX system administration and database administration.
  • Worked closely with the UNIX Administrator to plan and implement the best possible disk utilization and system storage for all database applications
  • Handled database management including development of databases, and monitoring and managing the security for databases on UNIX and NT platforms.
  • Worked with a variety of local area network systems linking PC's, scanners, and workstations with a UNIX server.
  • Installed and configured Oracle software (7.3.4, 8.0.5, 8i) on high end Unix Servers using Oracle Installer.
  • Work with System Administrators (UNIX & NT) and Oracle developers to ensure Oracle related matters are handled properly.
  • Accomplished the successful implementation of the database portion of a web based firewall security within both UNIX and Windows environments.
  • Design & implementation of SunOS/UNIX IPC mechanism API for development team using message queue, semaphore and memory mapped files.
  • Used UNIX shell scripts to automate database processes here in an environment more experienced administrators did not want to support.
  • Migrated UNIX based inventory and point of sale applications to PC desktop based wide area network across four stores.
  • Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
  • Performed Unix SA role by administering Unix SA related tasks like backups, h/w support and maintaining vendor relationship.
  • Developed UNIX Shell scripts for daily database logical backups, data retention, purging and other scheduled database procedures.
  • Created and modified UNIX Shell Scripts such as Job Archival scripts, file watchers, Email notification Scripts etc.
  • Parallel server is on Raw devices of UNIX cluster and dedicated DB servers are on UNIX File system.
  • Performed maintenance of OS patching and security management of 17 RHEL 4 hosts and 9 Tru64 Unix hosts.

Show More

10. Setup

high Demand
Here's how Setup is used in Database Administrator jobs:
  • Configured their production & non production databases for adequate performance and high availability using Disaster Recovery Planning with Active/Passive setup.
  • Experienced in schema usage, permission inheritance/chaining, linked server setup, backup/restore operations, and automated maintenance.
  • Worked on database setup documentation for Production instances and documented SQL server procedures and standards.
  • Developed database design, estimated database capacity and storage requirements, setup development environment.
  • Provided support to system parameters and setup and assisted with facilitating rate increase processes.
  • Plan Golden Gate setup to achieve unidirectional replication and setup user with privileges.
  • Install, configure and setup High-availability solutions including replication using Golden Gate.
  • Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
  • Configured and setup snapshot replication from production to Development environments.
  • Performed multitude of Desktop support functions and connectivity troubleshooting/setup.
  • Performed Production data refresh and setup of Development environments.
  • Configured and implemented Data guard setup for operation databases.
  • Standardized and formalized setup and execution of conversion environments.
  • Monitored and supported the replication setup including troubleshooting.
  • Created event orders detailing facility setup.
  • Write setup and install procedures documentations.
  • Project of Mumbai-Hyderabad warm standby replication setup
  • Managed e-mail setup and configuration.
  • Led the opening of two store location to include staffing, sales and product training, inventory setup and security controls.
  • Upgraded UAT database with schema patches, designed backup and recovery strategy, setup cold and hot backups on development servers.

Show More

11. Linux

high Demand
Here's how Linux is used in Database Administrator jobs:
  • Performed installations & configurations of Oracle databases on Linux and Windows platforms to assist the development department with product compatibility certifications.
  • Managed and administered Windows/Linux systems - Performed periodic maintenance, provided technical support and executed systems engineering.
  • Interact with Storage and Systems administrators on Linux/Unix/VM operating systems issues related to Databases.
  • Tune Linux operating systems, ensuring optimal functionality.
  • Utilized UNIX/Bash Scripting for general Linux administration.
  • Created and maintained Oracle 9.2.0.4 Data Guard standby databases for Electronic Invoice systems and Sports Lottery systems on Red Hat Linux.
  • Developed Windows2000 tools w/VB6 for backing up Linux/Apache Server Managing and support of all in-house, and third party vendor applications.
  • Upgraded and migrated Oracle Financial from Oracle 7 on HP-UX 10.2 to Oracle 11.2 on Linux x86-64 Red Hat 5 environment.
  • Install, create, upgrade and administer and maintain different databases on Linux 5.5, UNIX 5.10 and Windows 2003 environment.
  • Worked on RAC on red hat Linux advanced server with 4 nodes on server side load balancing using automatic storage management.
  • Developed an installation and set up guide based on company standards for Linux RHEL 4 in support of 3rd party applications.
  • Support and Administration in Development, QA, Pre-Prod and Production environments under platform consisting of Red Hat Linux and Windows.
  • Designed, developed and assisted with debugging complex SAS and SQL programs on OS/390, Oracle, Unix/Linux and Windows systems.
  • Administer 60+ 9i/10g/11g/12c Oracle databases in standalone, HA, and RAC environments on Windows, Unix, and Linux platforms.
  • Managed users accounts, privileges and access control, Utilize CRON job and Linux bash scripts for automation of backups.
  • Provide first level of service to the region by the use of Linux, Windows, Lotus and GPL software.
  • Experience installing and configuring SSH (Secure Shell) encryption to access securely on Ubuntu and Red hat Linux.
  • Employed Debian Linux with the Apache web server, MySQL database server, and PHP server side programming language.
  • Manage priority 1 and 2 systems on Unix, Linux and Windows, including RAC and Data Guard instances.
  • Installed & configured Red Hat Linux Advanced Server 4 on Development Servers & managed it for Oracle Database Environment.

Show More

12. Rman

high Demand
Here's how Rman is used in Database Administrator jobs:
  • Planned and organized database activities regarding reliability, performance monitoring and tuning, security, backup, and disaster recovery.
  • Utilized database modeling tools to document, review, and identify missing relationships to tune database and application performance.
  • Monitored the databases and optimized database performance and use of resources, including selecting optimal physical implementations of databases.
  • Tested new version releases to identify performance faults and prepared documentation and instructional materials for trainers and systems users.
  • Provided periodic management database system status reports and recommendations of additional hardware or changes that would increase system performance.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Involved in trouble shooting and fine-tuning of databases and system configuration parameters for better performance and concurrency.
  • Develop database Backup and Recovery and Disaster recovery strategies scheduling full and incremental backups using RMAN.
  • Monitor (Using Activity Monitor/Resource monitor/Performance Analyzer tool) and resolve the production performance issue.
  • Performed troubleshooting, analysis, and problem resolution to enhance database and instance performance.
  • Performed SQL performance monitoring and tuning to improve application response time and database performance.
  • Implemented and administered daily maintenance/upkeep jobs- including event log dumps, performance monitoring.
  • Configured DataGuard for physical and logical database and RMAN for off site Disaster/Recovery.
  • Conducted in-depth performance analysis of the Distributed Archive to meet customer performance requirement.
  • Enhanced database performance, implemented recovery procedures, and conducted regular system backups.
  • Produced, implemented, and monitored recommendations for performance improvement in hosted databases.
  • Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
  • Enhanced performance by reviewing disk configuration and storage allocation that increased storage efficiency.
  • Develop scripts to locate fragmentation levels and rebuild/reorganize Indexes to improve performance.
  • Provided proactive performance tuning and server monitoring for production and development environments.

Show More

13. Capacity Planning

high Demand
Here's how Capacity Planning is used in Database Administrator jobs:
  • Worked closely with the network administrator and senior developer in resolving issues related to capacity planning and procedures enhancing overall performance.
  • Involve in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
  • Performed logical and physical database design, and provided application SQL tuning, index analysis, capacity planning and database performance/tuning.
  • Performed Capacity Monitoring, short and long-term capacity planning in collaboration with development resources, System Administrators and System Architects.
  • Managed the production and development databases including extensive performance tuning, capacity planning, database security configuration and database continuity.
  • Implemented customer cost saving measures via database performance improvements and capacity planning strategies resulting in maximum efficiency of hardware resources.
  • Performed Capacity planning, audit, Performance of characteristics of production servers in current environment and estimate for future usage.
  • Managed database growth, conducted capacity planning; monitored, optimized and made recommendations to data storage for database systems.
  • Performed capacity planning for databases, application installation, performance/memory tuning, monitored servers/databases, configuration and troubleshooting.
  • Performed SQL server installations, capacity planning, backup and recovery, system monitoring and security administration.
  • Design and implementation Capacity planning and data archival procedures for regular functioning and maintenance of Production systems.
  • Provided capacity planning by projection of future database and system requirements based on collected statistics for Operations.
  • Perform capacity planning pertaining to memory and disk, establishing baselines for business and technical performance.
  • Administered effective capacity planning processes to ensure maximum performance and availability was inline with business expectations.
  • Provided suggestions to system administer regarding disk configuration, according to database sizing and capacity planning.
  • Plan and implement long-term capacity planning and infrastructure changes to maximize performance for all database components.
  • Perform tactical and strategic capacity planning working closely with System Admin staff and Solution architects.
  • Configured EM controls for 11g databases Perform capacity planning required creating and maintaining database environments.
  • Designed and implemented multiple databases including capacity planning for medium sized projects using Oracle 9i.
  • Involved in Capacity planning, monitoring, auditing, database/application performance optimization and other tasks.

Show More

14. Ssis

high Demand
Here's how Ssis is used in Database Administrator jobs:
  • Assisted in compatibility testing of software applications, including Travel management software and DOS-based COBOL systems for Overseas Buildings information.
  • Develop and implement behavior changing programs that assist, encourage and motivate individuals towards adopting healthy lifestyles and lifestyle habits.
  • Involved in providing technical assistance to developers in all matters concerning performance application related issues.
  • Update customer data base information to assist in business target objectives and uncover sales opportunities.
  • Assist with special projects involving advertising, customer referral program and marketing initiatives.
  • Handled collections, assisted personnel as needed and ensured efficient daily operations.
  • Assisted accused criminals obtain legal defense in an extremely fast paced environment.
  • Provide training and technical assistance on database to various academic units.
  • Provided operational and user assistance to address software and hardware problems.
  • Assist other senior developers to accomplish complicated tasks.
  • Handled routine correspondence and clerical assistance for department.
  • Provided application tuning assistance for SQL programmers.
  • Assist in numerous processes of merger/acquisitions transition.
  • Provided assistance to Senior Database Administrator.
  • Assist notes developers with database enhancements.
  • Assisted customers in merchandise selection.
  • Assisted in the creation of a fast provisioning process that automatically installs Oracle and creates Oracle databases in a Linux environment.
  • Created and managed DTS and SSIS jobs to perform extra back up support for company's back up agent and procedure.
  • Assisted in ETL development efforts, making sure that the business rules are implemented correctly and clarifying issues as they arise.
  • Assist the Detroit Economic Growth Corporation in the identification and implementation of energy conservation measures within the public and private sectors.

Show More

15. Production Environment

average Demand
Here's how Production Environment is used in Database Administrator jobs:
  • Defined and implemented production environment, migrated databases from development to production environment, Prepared DB production support transition documentation.
  • Automated Development and Production environment synchronization to ensure developers were able to develop their code on a Production like environment.
  • Involved in performing database refresh from production to non-production environment using RMAN duplicate and RMAN restore and recover methodologies.
  • Perform Database administration and support services for a propriety Oracle database Application in Test, Development and Production environments.
  • Designed and implemented SQL Server 7 for inventory and production environment which included data warehousing design and constraints.
  • Work closely with development staff to redesign and optimize databases and prepare them for implementation into production environment.
  • Create databases and documents procedure to migrate and refresh databases between the development and production environments.
  • Developed project plan and specification needed to migrate newly application system over to a production environment.
  • Managed the process of migrating databases from development stage to testing and subsequently to production environments.
  • Functioned in a 24x7 production environment using Data Guard in distributed & heterogeneous replicated environment.
  • Reviewed customer's requirements and prepared scripts and enhancements to be implemented in production environments.
  • Performed Database recovery (including redirected restore) in production environment to resolve storage issues.
  • Maintained various environments like development, integration test, performance test and production environments.
  • Provide 24x7 tech support and perform analysis on infrastructure related projects for production environment.
  • Developed standards and procedures for the migration of development systems into a production environment.
  • Help create and maintain operational documentation to support the solution in a production environment.
  • Deployed database and server level changes to production environments during scheduled system outage windows.
  • Managed System Users, security and system monitoring for development / production environment.
  • Monitor production environment and set up automated processes to improve overall data productivity.
  • Defined backup/recovery plan that used RMAN to support both development and production environments.

Show More

16. Solaris

average Demand
Here's how Solaris is used in Database Administrator jobs:
  • Supported an environment consisting of Oracle 9i and 10g RAC and standalone databases on SunSolaris, Microsoft Windows 2003 Server.
  • Helped support ORACLE database environments to include installs/patches (SOLARIS 10g to 10.2).
  • Worked on different platforms such as LINUX, SUN SOLARIS, AWS and Windows.
  • Constructed, implemented and administered several Solaris 9 and Oracle 10g/9i servers to support application development team.
  • Developed and implemented monitoring shell scripts on Solaris and Windows platforms.
  • Maintain the Enterprise oracle I-learning applications on solaris operating system.
  • Installed/Configured/administered ORACLE 8i on Sun Solaris.
  • Administer Sun Solaris web/ftp/database servers.
  • Administered 50 Oracle databases and Oracle Application Server instances on 15 Sun Solaris and Windows servers supporting applications in various departments.
  • Created RAC databases using manual method and DBCA method on both Solaris 5.10 and on RHEL 4 and on 5.1.
  • Sole administrator of Oracle production, development, and training databases on Solaris system for Fortune 500 mortgage corporation.
  • Administer multiple development and production database servers running: Oracle on MS Windows NT and Oracle on Sun Solaris.
  • Planned and executed the cross platform migration of Oracle databases from Sun Solaris servers to IBM RS6000 servers.
  • Converted legacy data into four Oracle 8i databases running on three Sun Solaris servers supporting 150 corporate users.
  • Moved a 1.2 TB Data Warehouse with three years of partitioned data from 9i/Solaris 5.8 to 10g/RedHat 4.
  • Performed database creation, deletion, backup, recovery, data migration from Solaris to the LINTEL cluster.
  • Design, implement, and support high performance, mission critical Oracle databases and application systems on Solaris.
  • Involved in the planning and migration testing of 800+ databases to Oracle 12C on new Solaris 11 builds.
  • Used Rapid Clone method created additional TEST, ADMIN and PROD instances (11.5.8 on Solaris 8).
  • Migrated Oracle 8.1.7 Development Database (under NT) to Oracle 9.2 production (under Sun Solaris).

Show More

17. Troubleshoot

average Demand
Here's how Troubleshoot is used in Database Administrator jobs:
  • Maintained web-based data entry system * Maintained project tracking database * Developed reports * Performed troubleshooting and problem resolution for end users
  • Provided configuration adjustments, as well as general support and troubleshooting for eleven databases on multiple production and development servers.
  • Performed extensive troubleshooting, performance tuning, and data modeling / redesign activities for the company's telecommunications billing system.
  • Performed space estimation and calculation, application installation, performance/memory tuning, server/database monitoring, configuration, and troubleshooting.
  • Provided technical support to every Provincial Network Center: maintenance, troubleshooting and tuning operational databases.
  • Performed preventive maintenance, troubleshooting, and provided remote administration support for 9 mission-critical Oracle databases.
  • Maintain and troubleshoot IT problems for department personnel- including network connectivity and general computer problems.
  • Provided database support to application developers and assisted technical troubleshooting Microsoft Windows server operating system.
  • Involved in creation of distributed partitioned views, debugging/troubleshooting stored procedures, upgrading existing ones.
  • Coordinated with off-site support activity for troubleshooting and repair of database and hardware related problems.
  • Created Services Migration Troubleshooting and support methodology to Remove Bottlenecks in migration support process.
  • Performed SQL database planning, implementation, maintenance, performance tuning/improvement, troubleshooting.
  • Supported custom application development team including database objects deployment, migration and troubleshooting.
  • Performed troubleshooting and resolution of user connectivity, hardware and application deployment issues.
  • Maintain and troubleshoot all scheduled database functions on production and development servers.
  • Provide technical support for troubleshooting and fixing of Business Objects/Crystal Reports applications.
  • Ensured exceptional customer satisfaction levels by proactively responding to and troubleshooting issues.
  • Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
  • Assist developers with troubleshooting/optimizing/tuning stored procedures and optimized utilization of indexes.
  • Performed diagnosis, troubleshooting and debugging of highly technical billing system.

Show More

18. ETL

average Demand
Here's how ETL is used in Database Administrator jobs:
  • Led BI/ETL data delivery effort building and maintaining tables for Corporate Security investigations.
  • Provide operational/development SSIS support for ETL failures and package modifications.
  • Developed ETL packages for data transfer adhering to Government regulations.
  • Created intranet site in vb.net to display status of automated ETL processes, which I later migrated to cold fusion code.
  • Designed and developed ETL scripts using External Tables, SQL and data pump features to load 20-30 million records a day.
  • Performed data cleansing, data scrubbing as part of ETL while moving the data from different data sources to OLAP Databases.
  • Review and create Extraction, Transformation, and Loading (ETL) processes for optimal access and data manipulation methods.
  • Created and modified stored procedures to load data from an ETL process from an operational database to a BI database.
  • Integrated output of this module with ETL packages to evaluate, transform and load crawled data into Factory databases.
  • Created SQL Server stored procedures, jobs, functions, views, indexes and tables to build ETL feeds.
  • Created mapping document for all the above 4 environments and ETL design document for the ETL developers to code.
  • Developed UNIX Shell scripts, complex SQL and PL/SQL scripts for Data extraction from different data sources for ETL.
  • Created SSIS packages for ETL operations and transfer large volumes of data from Oracle to SQL Server 2005 databases.
  • Acted as DBA and ETL specialist in the initial development of a customer data warehouse for Isle of Capri.
  • Reduced processing time of ETL processes by more than 1000% to increase efficiency and reduce system resource usage.
  • Developed the ETL standards for the database migration from legacy Mainframe server applications to SQL 2005/2008 using SSIS.
  • Build custom Clarity ETL solutions to satisfy data requirements outside of the standard Clarity ETL extracts via SSIS.
  • Used INFORMATICA Power center for ETL process from oracle OLTP databases, flat files into OLAP oracle databases.
  • Designed, Built ETL procedures and a data warehouse to meet client requirements using SQL Server Integration Services.
  • Gained 40% more performance by using direct-path load (SQL* loader) for bulk loading ETL data.

Show More

19. RAC

average Demand
Here's how RAC is used in Database Administrator jobs:
  • Coordinated several contractors simultaneously to decrease inconvenience to home owners resulting in professional and timely completion of each phase of construction.
  • Captured production database and schema design into Oracle's CASE management repository and generated reports, documentation, design analysis.
  • Prioritized, distributed and tracked ongoing projects to ensure accuracy and timely completion of projects.
  • Installed and Configured Oracle Process Manager to monitor and administer various component of Application Server.
  • Manipulated a Recovery Case Tracking database to produce client monthly billing and to track productivity.
  • Researched, compiled and analyzed information to track the company progress and customer satisfaction.
  • Manage Oracle database administration assignments for critical Oracle database systems in a dynamic environment.
  • Provided database administration/on-call support for mission-critical applications and Oracle databases.
  • Network connectivity configuration between client and server using oracle net.
  • Designed and documented standardized Oracle RAC deployments using cloning methodology.
  • Configured and administered BMC database monitoring tools for Oracle databases.
  • Maintained the integrity and accuracy of the geographical information database.
  • Interacted with 150-200 people daily establishing/maintaining excellent customer/staff relationships.
  • Provided contract administration working closely with franchise owners.
  • Negotiated all insurances and business related contracts.
  • Track advertising expenditures and database coupon library.
  • Tracked and logged incoming/ outgoing inventory.
  • Negotiated and contracted wholesale preferred accounts.
  • Calculated estimated cost of jobs, wrote contracts and customized budgets to meet client needs and desires for a quality project.
  • Developed scripts to load data into Oracle coming from non-Oracle sources like SAP, People Soft, Fidelity, Hewitt etc.

Show More

20. Data Warehouse

average Demand
Here's how Data Warehouse is used in Database Administrator jobs:
  • Project grew into corporate data warehouse environment storing information on all B2B relationships resulting in significant improvement in operations efficiency.
  • Performed logical and physical database design; designed data warehouse/data mart for the pharmaceutical sales and marketing departments.
  • Assisted data warehouse developers in minimizing performance bottlenecks of the reporting database and troubleshooting any problems that arose.
  • Created an Oracle data warehouse supplying timely key performance indicators for analysis on crucial business operations.
  • Identified and documented data sources and transformation rules required to populate and maintain data warehouse.
  • Analyzed existing data leading to recommendations for architectural changes to the existing DB2 data warehouse.
  • Perform Data Warehouse Design using Star Schema, Entity-Relationship diagram, and Normalization Process.
  • Participated in a corporate wide effort in analyzing and designing a data warehouse system.
  • Created an efficient Data Warehouse for repository backups and recovery control purposes.
  • Developed data warehouse delivery systems and currently support new data warehouse system.
  • Implemented and maintained Oracle Data Guard/Golden Gate databases for Data warehouse/Reporting purposes.
  • Analyzed user requirements and created centralized data warehouse mechanism using oracle.
  • Managed data warehouses, including data requirement analysis and tools selection.
  • Installed and maintained several databases including data warehouse.
  • Designed, developed and implemented a data warehouse.
  • Tune initialization parameters for the DoS data warehouse.
  • Implemented indexing in data warehouse to improve performance.
  • Involved in designing a Data Warehouse analysis project.
  • Involved in the Data warehouse/ETL development and operations.
  • Developed scripts to automate population of data warehouse.

Show More

21. DB2

average Demand
Here's how DB2 is used in Database Administrator jobs:
  • Perform all DB2 database administration functions for a Milwaukee-based provider of network services for agricultural businesses.
  • Maintained DB2 Data Dictionary, CDM and non-CDM application performance improvements and logical/physical design optimization.
  • Worked as mainframe Db2 database administrator for manufacturing application Product Manager.
  • Participate in developing checkpoint/restart, backup and recovery DB2 standards.
  • Provided physical DB2 database analysis and DB2 database modifications.
  • Generated reports of database statistics using DB2LOOK Utility.
  • Co-designed back-end structure for departmental DB2 database.
  • Performed mainframe DB2 database administration and support.
  • Manage DB2 database administration telecommunications billing systems.
  • Develop, implement, and monitor data transfer from Legacy mainframe IMS and DB2 environments to SQL Server 2008 R2 databases.
  • Involved in successful DB2 upgrades, operating system upgrades and disaster recovery exercises by working with other systems and application teams.
  • Developed DB2 access path analysis tool to identify and facilitate review of critical DB2 plans that use high amounts of CPU.
  • Managed data replication from AS/400/DB2 to Windows 2003/SQL Server 2005 using Transformation Server by DataMirror (recently acquired by IBM).
  • Pull the DB2 data into SQL server and bring the SQL region sync with DB2 region using the SQL Merge functionality.
  • Collected, maintained, and reviewed system performance statistics to ensure efficiency of DB2, IMS, and SQL Server databases.
  • Use tools like db2advise, db2look, db2move and db2adutl to monitor, analyze and make changes in the database.
  • Administered and performance tuned up to 15 MS SQL Servers 2000, Oracle and DB2 databases to 5 development centers.
  • Monitor the memory usage at Instance, Database, Application and agent level using db2mtrk utility and escalate if needed.
  • Requested to upgrade the POS Db2 database versions, performance and improve all POS stores' build speed and performance.
  • Used IBM as well as internal reports, determined changes to DB2 objects and discover changes required to application programs.

Show More

22. Ssrs

average Demand
Here's how Ssrs is used in Database Administrator jobs:
  • Develop and maintain SSRS reports using relational and analysis services databases.
  • Provide application and financial reporting support using SSRS to related departments.
  • Rendered multidimensional data into complex formats using SSRS report writer.
  • Set up enterprise reporting environment using SSRS
  • Configure OBIEE and SQL Reporting Services (SSRS) for Developing Drill Tabular Reports, Matrix Reports and Drill Down Reports.
  • Developed various Operational Drill through, Drill down, Tabular and Matrix reports using SSRS, Tableau and Microsoft Power BI.
  • Handled upgrades, installation, and configuration of SQL databases and related components (SSRS, SSIS, and SSAS).
  • Manage of backup of the information, use of SSRS to get information about the variation of volume monthly and weekly.
  • Installed and configured SQL server 2008 Reporting Services (SSRS), managed security built reports and deployed them to production.
  • Created and implemented Reporting Services (SSRS) and Analysis Services (SSAS) and OLAP for Different application to use.
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Created BI reports utilizing the Microsoft Business Intelligence tools to include SSRS and distributed to be used by international staff members.
  • Designed, deployed, and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports.
  • Create SSRS reports by communicating with the supervisors from different programs and departments to track the productivity of the organization.
  • Implemented many SQL 2005, 2008 and 2008 R2 (SSRS) Reporting Services Servers in a Web Farm environment.
  • Develop means to effectively monitor up to 2 million transactions daily using SSIS/SSRS routine to organize and test audit traces.
  • Used SSIS and SSRS for database administration, as well as reports for users, to simplify day-to-day routine processes.
  • Generated Daily, Weekly, Monthly, Subscriptions for the analysis of managers and end users by using SSRS.
  • Involved in SSIS package & SSRS design and helped to application team to deploy /configure packages in database server.
  • Up gradation of SSRS reports to higher version (successfully implemented between SQL 2005 to SQL 2008).

Show More

23. T-Sql

average Demand
Here's how T-Sql is used in Database Administrator jobs:
  • Designed and implemented the integration of Reuters upgrades/downgrades feeds into Fidelity Investments local databases written in Transact-SQL.
  • Authored advanced T-SQL procedures to accommodate development needs.
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Worked with application team to implement, test, and enhance stored procedures, views, functions and other T-SQL scripts.
  • Implemented a process to check the health of SQL servers on a daily basis using a combination of PowerShell and Transact-SQL.
  • Maintain backups using native SQL Server tools, Red Gate SQL Backup, and T-SQL scripts for all company databases.
  • Provided T-SQL and PL-SQL tuning for application developers, improving performance on slow running queries used to manage customer relationships.
  • Experience in writing and reviewing T-SQL code, maintaining coding standards across the board in all SQL Server environments.
  • Created various reports with T-SQL according to the business requirements for the company using SQL Server 2005 Reporting Services.
  • Developed approximately 15-20 custom downtime, production, and auditing reports using with T-SQL, MS Excel and Access.
  • Managed application development team; acted as application architect and project manager, sole DBA and lead T-SQL developer.
  • Experience in creating new database objects like Tables, Stored Procedures, Queries, Indexes and Views using T-SQL.
  • Developed reports using Crystal reports with T-SQL, JDE Report Design Aid, MS Excel, and Access.
  • Tested programs or scripts (in PL/SQ and T-SQL), corrected errors, and made necessary modifications.
  • Developed Stored Procedures in T-SQL using Query Analyzer including CURSOR data structure for monthly database purge and archival.
  • Trouble shooting and development of T-SQL scripts to work around known and unknown issues in Database migration Process.
  • Extracted data using T-SQL to build reports in MS Excel, MS Access, and Crystal Reports.
  • Provided performance tuning for Oracle and MS SQL Server databases as well as SQL and T-SQL scripts.
  • Write advanced T-SQL and scripts to tune slow performing queries, as well as automate our monitoring.
  • Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.

Show More

24. OEM

average Demand
Here's how OEM is used in Database Administrator jobs:
  • Implemented central monitoring and alerting system-using OEM.
  • Estimate or quote prices, credit or contract terms for large OEMS and Rental accounts along with warranties and delivery dates.
  • Perform upgrades and quarterly patching on all supported Oracle databases as well as Oracle Enterprise Manager (OEM) 12c.
  • Utilized SQL and OEM to create primary Oracle database storage structures and extended table space and data file sizes.
  • Used STATSPACK, PERFSTAT and OEM included suite of tools to tune SQL queries and resolve problematic SQL statements.
  • Conducted real time monitoring of database performance during critical production releases using OEM, ASH and ADDM reports.
  • Managed OEM and agents installation on server and node Tuned database server, application logic, database objects.
  • Installed Oracle Application Server and configured Oracle Forms and Reports, and OEM to run on the Web.
  • Coordinated efforts with other channels of distribution, fostered OEM partnerships, and supported maintenance of existing business.
  • Use OEM to monitor and maintain the Database / Objects, to refresh the Snapshot Replication Groups.
  • Managed and monitored standby database using broker as well as monitoring primary database by using OEM 12c.
  • Configured OEM for several databases including UAT, DEV, TST, STG and to PRD databases.
  • Implemented three separate OEM 12c systems and serve as the OEM System Administrator for all three locations.
  • Performed as an honest broker between the OEM and the PMO to ensure quality checks of data.
  • Created OEM jobs in order to monitor system events, analyze database tables, export/import data.
  • Used OEM (Oracle Enterprise Manager) and DBA Studio for day-to-day activities on the databases.
  • Configured, administered, and monitored a Streams environment using various tools like OEM console.
  • Write, edit and revise procedures, practices and policies for both OEM and Repair.
  • Install and configure Oracle 9i Client Enterprise Manager (OEM) and 10g Database Control.
  • Install and configure OEM 13c as our main monitoring tool for the entire database environments.

Show More

25. QA

average Demand
Here's how QA is used in Database Administrator jobs:
  • Implemented separate development, QA and production Server environments; Assisted in constructing release management processes.
  • Provided database related services to their development & QA environments as Database Refresh/Cloning and Object Migration.
  • Refresh Development and Certification databases on demand from Production databases for developers and QA testers.
  • Synchronize data between Development, QA and Production Environments following SOX Change Management methodologies.
  • Create user and technical documentation for Production, Development and QA database environments.
  • Coordinated development and QA database refreshes with business analysts and user community.
  • Refresh User Development/Test/QA databases from production data.
  • Refresh of development/test/QA databases from production backup.
  • Produced additional savings by working overtime for the QA department, eliminating the need for the company to hire extra personnel.
  • Developed and executed modules for generating claims data for load/test performance purposes and handling QA database for the State of Maine.
  • Assist Application DBA's with issues in development, QA and production servers for multiple applications in EE and EEE environment.
  • Performed Schema comparison for databases in different environments like Prod, UAT, QA and Development boxes using SQL Compare.
  • Attend meetings with developers, QA and Database Management Office to manage database changes, deployments, change control systems.
  • Provided Oracle/SQL Server database administration of production, development, test and QA databases on both HPUX and NT platforms.
  • Cloned production database for testing, development, QA environment using export/import, cold backup, hot backup and RMAN.
  • Involved in developing test plans and test cases in collaboration with the database and the QA team for the application.
  • Delivered quality of work through QA/QC, followed projects through billing process to verification and field validation to reconciliation.
  • Reduced bi-weekly QA data refresh labor from 8 hours to 1 by purchasing additional disk space to simplify process.
  • Carried out V2R6 to TD12 software upgrade on their Test, QA, Maintenance, Development and Production systems.
  • Verified that scripts/packages worked properly before transfer to QA for user acceptance testing (UAT) and subsequent production.

Show More

26. Sybase

average Demand
Here's how Sybase is used in Database Administrator jobs:
  • Provided telephonic support for installation of SYBASE and application at various customer locations.
  • Administered Oracle-Sybase, Sybase-Sybase replication.
  • Implemented Monitor Server with Historical Server and Crystal Reports front end to analyze SYBASE SQL SERVER performance data.
  • Assisted in the migration of a financial database system to a SYBASE database.
  • Implemented Engine groups and Execution Classes to improve the SYBASE Server performance.
  • Helped standardize both our SYBASE and MS SQL Server Database environments.
  • Migrated SYBASE ASE 15 to oracle 10g using golden gate.
  • Managed migration project to SUN 690 with 4.9.2 SYBASE.
  • Installed and maintained nine databases on a SYBASE platform.
  • Design and implement heterogeneous bidirectional data capture/replication between Oracle and Sybase, well as between Oracle and Oracle.
  • Develop backup & recovery procedures and disaster recovery procedures for Sybase and SQL Server databases.
  • Participated and supported in Enhancement of JPM-Heritage in-house tool OperMenu for housekeeping tasks for Sybase servers
  • Promoted product maturity by data model creation, documentation and maintenance using Sybase PowerDesigner.
  • Performed Sybase System Administration functions, including device allocation, security, data loading.
  • Developed scripts to automate routine administration functions for Sybase and Replication server.
  • Developed Sybase database for Decision Support System for reporting and customer support.
  • Help standardize/troubleshoot NT desktop packaging regarding Oracle/Sybase clients on NT.
  • Prepared statistical reports and technical documentation of all Sybase servers.
  • Initial responsibilities were providing physical DBA support for Sybase databases.
  • Implemented Remote Sybase BackupServer process to expedite database dump routines.

Show More

27. DTS

average Demand
Here's how DTS is used in Database Administrator jobs:
  • Designed, through DTS, a data migration process to import vital state data from Oracle servers to our Access database.
  • Developed user-defined functions and numerous T-SQL stored procedures, many of which would interact with DTS packages and operating system commands.
  • Experience using DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Modified DTS, SSIS ETL package for changed business requirements to load data from different source files to SQL Server tables.
  • Exported and imported data from text files and Excel to SQL Server database using SSIS, DTS packages and BCP utility.
  • Maintained DTS packages for OLAP data feeds, and assisted OLAP administrator with ETL process design, creation, and implementation.
  • Worked with application teams in migration of databases from SQL 2000 to SQL 2005 involving DTS to SSIS, Report server.
  • Performed Data migration (import and export) from Text to SQL Server and data transfer using BCP and DTS.
  • Exported data out to files using SQL Server DTS and input the data file in into the new Oracle database.
  • Used DTS to clean up the data by removing all unnecessary data being transfer form one database to the other.
  • Implemented DTS jobs, stored procedures, views, access control, and performance tuning in a DataWarehouse DBA role.
  • Monitor SQL databases and servers, migrate data between environments, including tables, views, stored procedures, DTS.
  • Design Database Transformation Services (DTS) packages and SSIS to import and export the data in from SQL Servers.
  • Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
  • Design and Creating DTS Packages to load and process data from flat files and Other RDBMS databases to SQL Server.
  • Develop stored procedures and DTS packages to automate SQL tasks on servers deployed throughout the Northern Iraq area of operations.
  • Design, Create, and support DTS Packages to load and refresh data warehouse, and to sync data environments.
  • Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Created and modified many DTS SSIS packages also stored procedures as per need on both third party and institutional environments.
  • Created standardized DTS package design models to expedite development time and ensure each transformation process conforms to the database standards.

Show More

28. AIX

average Demand
Here's how AIX is used in Database Administrator jobs:
  • Supported AIX/Unix/Linux operating systems and familiar with basic Windows system administration.
  • Designed a database with a star schema, created and administered DB2 UDB database on AIX for a data- warehousing project.
  • Designed, customized, implemented and tuned DB2, UDB and IMS databases and elements on AIX, Linux and z/OS.
  • Project Description: In IBM, we maintained nearly 1500 databases in windows NT/2000/2003 and also some servers are of AIX.
  • Collected, monitored, and analyzed database performance statistics and utilized information to make configuration changes to the database and AIX.
  • Led a four-person DBA team in a full Oracle 10G RAC implementation that involved three-node RAC clusters on AIX 5.3.
  • Provided DB2 Installation, Configuration, Maintenance and Tuning of DB2 Database on AIX/ UNIX, Linux and Windows platform.
  • Supported IBM AIX Power 7 server to Power 8 server migration to reconfigure RAC network configuration using SRVCTL and OIFCFG.
  • Contributed to cost saving initiatives by leading an AIX server consolidation project with an average cost savings of $75K/year.
  • Installed, configured and managed Oracle 8i, 9i on HP-UX and IBM-AIX environments for production, test and development.
  • Install Agents and Targets on the new em12c Grid Control for all the Linux/AIX that hosts the Operational DB systems.
  • Installed Oracle binaries (9i and 10g) on Windows and AIX in development, testing and production environments.
  • Provided documentation on db2look, db2export, db2import and db2load on the AIX 6000 and the Window 2000 server.
  • Implemented new DB2 for z/OS subsystems to support a new implementation of SAP release 4.6C running on AIX servers.
  • Maintain High Availability Clustered Multi-Processing (HACMP) environment for IBM DB2 UDB on the AIX operating system platform.
  • Designed, configured and installed all major production, development and test Oracle database environments on Unix AIX platforms.
  • Install, configure and perform upgrades on Oracle DBMS software and related tools in AIX and NT environments.
  • Involved in discussions with the management regarding the advantages/disadvantages during the OS migration from AIX to SUN SOLARIS.
  • Optimize, monitor, and tune the performance of DB2 UDB database servers on both AIX and Linux.
  • Manage multiple corporate financial, payroll and business Oracle production databases on IBM AIX and MSSQL on Windows.

Show More

29. Data Entry

average Demand
Here's how Data Entry is used in Database Administrator jobs:
  • Facilitated meetings, trained staff, managed data entry quality and collected/analyzed data to evaluate impact of program.
  • Innovated time-saving data entry, customizing dynamic import utility tools to import data into our database system.
  • Customized insurance sales & prospecting data reporting application, offering data entry and customized reporting options.
  • Consolidated databases for seamless and efficient school-wide integration of data, eliminating duplication of data entry.
  • Assisted with resolving data entry system problems by coordinating preparation of reports, analyzing data.
  • Cross trained to assist Data Entry/Clinical Department by attaching faxed medical records to authorizations requests.
  • General office responsibilities included data entry, answering telephones, filing and ordering supplies.
  • Monitored daily quality of data entry and provided quality control of database.
  • Managed and maintained the facilities and equipment database for data entry accuracy.
  • Maintained a corporate ORACLE database of subcontractors involving high-volume data entry.
  • Performed data entry for the Behavior Management and Incident Reporting databases.
  • Performed extensive data entry with a heavy caseload and time-sensitive deadlines.
  • Developed and maintained databases for company wide data entry and reporting.
  • Utilized data entry and auditing to accurately compile computerized borrower records.
  • Managed employees performing data entry in addition to database administration.
  • Provided necessary data validation checks against the data entry.
  • Performed data entry of payment information and customer information.
  • Developed application that eliminated data entry by the user.
  • Developed internal procedures for data entry and inventory management.
  • Designed specifications/layouts for Data entry screens and reports.

Show More

30. Performance Issues

low Demand
Here's how Performance Issues is used in Database Administrator jobs:
  • Investigated and resolved performance issues with their newly installed and critical 3rd-party warehouse management system that drives the distribution centers.
  • Investigated and resolved key performance issues, initiating process and system improvements to increase system stability and staff productivity.
  • Evaluated performance issues on complex transactions in live environments and provided designs to mitigate or eliminate.
  • Worked with application developers and architects resolving performance issues with RAC database connections through firewall.
  • Have identified bottlenecks and providing recommendation for solving critical performance issues and database problems.
  • Worked on Online Journal performance issues while simulating150 concurrent users creating/editing and attaching Journals.
  • Analyzed database performance issues on regular basis and conducted tuning activities for improvement.
  • Performed database and system analysis to perform process optimization, diagnose performance issues.
  • Top level database quality support including performance issues, infrastructure installation and optimization.
  • Performed troubleshooting various operational issues including replication failures and performance issues.
  • Identified and made recommendations for resolution of system performance issues.
  • Implemented recovery procedures and monitoring the system for performance issues.
  • Identified and resolved database performance issues, database capacity issues.
  • Experience in resolving performance issues related to interconnect.
  • Resolved numerous most challenging database performance issues.
  • Analyzed performance issues and recommended solutions.
  • Worked extensively on performance issues.
  • Enable TraceFlags to help diagnose performance issues as well as RCSI Read Commit Snapshot Isolation to help reduce blocking on select/read statements
  • Worked closely with the application teams, Unix Teams to work on Performance issues, DB bottlenecks, I/O contention issues.
  • Identified and fixed performance issues on production systems by using Quest software, TOAD, Spotlight, and manual SQL scripts.

Show More

31. Technical Support

low Demand
Here's how Technical Support is used in Database Administrator jobs:
  • Performed physical database design and implementation, technical support, tuning and maintenance of the corporate database environment.
  • Provided guidance and technical support in the procurement of government contracts related to military base telecommunications upgrade programs.
  • Provided interface and technical support to Sales and Marketing department for new product introduction and product development.
  • Provide administrative/technical support to the Engineering group by assisting in the maintenance and creation of manufacturing records.
  • Managed department metrics database providing technical support and maintenance to maintain the referential integrity of the system.
  • Service Provider: Provided systems and application end-user technical support, documentation, training and reporting.
  • Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement.
  • Provided technical support on a daily basis for maintaining/upgrading/tuning the Databases on their various platforms.
  • Provided technical support to users and application teams, performed troubleshooting of application related issues.
  • Provided technical support as the troubleshooter/problem solver/help desk and coordinated training sessions as needed.
  • Provided Technical Support in configuring, and maintaining Data over shared and distributed networks.
  • Worked with Technical Support team to resolve technical system issues affecting proper account reconciliation.
  • Handled complaints by resolving them independently or with assistance of technical support representatives.
  • Provided in-house expertise and technical support to end-users on database and software-related issues.
  • Resolved implementation/installation issues and served as technical support for developers and analysts.
  • Provided implementation and technical support to multiple development and performance engineering teams.
  • Provided technical support and subject matter expertise to customers utilizing our products.
  • Performed technical support to and irate customer reporting a damaged driver.
  • Provided technical support for users worldwide in maintaining client connectivity software.
  • Provide PeopleSoft technical support for application servers and process schedulers.

Show More

32. Grid

low Demand
Here's how Grid is used in Database Administrator jobs:
  • Developed and maintained stored procedures that are used for in-house applications, performance metric grids and automated reporting.
  • Designed and developed alerting mechanism for several databases using Shell scripting and Grid control.
  • Implemented Oracle Enterprise Manager - Grid Control for centralized monitoring and administration of applications.
  • Participated in standing up Grid and Data Guard configuration for high availability solution.
  • Improved database monitoring by defining automated real-time daily status reports of grid agents.
  • Implemented Oracle Grid Control for monitoring all research and manufacturing databases.
  • Performed troubleshooting on grid configurations to maintain a stable environment.
  • Monitored and administered databases using Oracle Grid Control.
  • Experienced in installing Grid Infrastructure and configuring ASM
  • Configured and maintain Grid Control Repository.
  • Stabilized Oracle Grid Control environment.
  • Developed and deployed custom user metric for proactive monitoring of the portal system by extending the Grid OEM System for notifications.
  • Involved in Tuning the RAC interconnect Finding RAC wait events and tuning the Databases using the Enterprise Manager Grid Control 11g/12c.
  • Installed and configured RAC (2 node) and Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3.
  • Implemented ASM on grid environment with data partitioning with data files and the fast recovery area all located on ASM.
  • Configured Grid Control monitoring metrics and email alert notifications, which are used to detect and address critical database issues.
  • Installed the 12c Enterprise Manager Grid control to monitor the performance and administration of the Oracle Databases and application servers.
  • Worked on Oracle 10g/11g RAC implementation using ASM and SAN technology and on deployment of Oracle Grid Control monitoring infrastructure.
  • Implemented and administrated high availability solutions using Standby Database, Oracle Data Guard, Oracle RAC and Grid computing.
  • Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass Agent Deployment on several hosts.

Show More

33. Internet

low Demand
Here's how Internet is used in Database Administrator jobs:
  • Restructured Purchasing Department with a streamlined staff and improved productivity through the implementation of MARS information technology and Internet based suppliers.
  • Performed activities related to maintaining a successful DB2 Database environment by ensuring maximum up time for a billion dollar internet/retail/catalog business.
  • Designed, created and implemented automated job status checking system to ensured maximum data integrity for global internet user community.
  • Designed, developed, deployed and maintained complex geographic databases supporting Internet mapping applications as well as multidisciplinary academic research.
  • Collaborated with computer and Internet Application Program Developers in the smooth operation of databases with new and established applications.
  • Disseminated market competitive information and developed competitive pricing models and products to launch High-Speed Internet and voice services.
  • Prepared materials for presentations and training sessions, sent/received correspondence, handled travel arrangements, internet research.
  • Provide database administration support for large-scale, high-volume internet web sites, and various intranet/corporate applications.
  • Processed all SWANA internet store orders: event registrations, membership additions/renewals & physical/electronic merchandise.
  • Managed the development and implementation of internet-based credit card and check authorization application.
  • Maintained internet mail gateway and ensured accessibility and availability of national hub server.
  • Managed user/security administration, researched Oracle Internet Directory (OID) implementation.
  • Instituted a process to efficiently use internet registration information for large events.
  • Manage database administration assignments for this internet based pet supply company.
  • Trained and monitored an artificial intelligence program which categorized internet websites.
  • Implemented security mechanisms in Oracle database in intranet and Internet systems.
  • Coordinated conference room scheduling; including internet connectivity and AV equipment.
  • Conceived, developed unique internet advertising campaign and marketing strategies.
  • Researched information via telephone and internet to complement survey data.
  • Gathered business development contact information through internet and phone research.

Show More

34. Toad

low Demand
Here's how Toad is used in Database Administrator jobs:
  • Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
  • Developed a DBA security data ERD in Toad, and forward engineered it for implementation in an Oracle 11g database.
  • Use Toad for Oracle and Oracle SQL Developer to compare Oracle data, and view and compare Oracle object structures.
  • Project - Internal SAP Application DBA, Chennai, India Database/Application/Tools used: Oracle 9i, 10g, Toad.
  • Developed PL/SQL, TSQL Stored Procedures, Packages and triggers using SQL Plus, TOAD and query Analyzer utilities.
  • Provided Third level support to the production side with the help of third party tool, TOAD.
  • Involved in database designing, created logical and physical models with modeling techniques using TOAD Data Modeler.
  • Worked with TOAD as an interface to databases, to analyze, view and alter data.
  • Administer, implement, and maintain Oracle databases on Windows platforms using OEM and Toad.
  • Created Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Navigator.
  • Utilized BladeLogic for patch management of servers and Toad for Oracle for database administration.
  • Perform database and SQL tuning using Explain Plan, Enterprise Manager, and Toad.
  • Worked with Database Monitoring tools like TOAD, BMC PATROL and Log Miner.
  • Used TOAD and PLSQL developer tool for debugging the packaged procedures and functions.
  • Use of Toad by Quest Software to diagnose data issues and correct problems.
  • Used TOAD to monitor and do performance tuning to fix long running queries.
  • Generated various performance reports like SQL base comparison report etc using TOAD tool.
  • Worked with Oracle 9/TOAD to obtain reports and critical metrics for management.
  • Tuned SQL statements using oracle and third party tools such as TOAD.
  • Tuned SQL queries using explain plan generated in TOAD and SQL Navigator.

Show More

35. CPU

low Demand
Here's how CPU is used in Database Administrator jobs:
  • Analyzed CPU/Memory/Disk requirements and performance.
  • Monitor cost per unit (CPU) and ensure each vehicle nets the highest revenue per unit (RPU) possible.
  • Monitor, Error Log, database file space and file system space usage, CPU utilization and solve problem as needed.
  • Tune databases, applications, monitor performance of database servers, related processes CPU, memory, storage, and network.
  • Install, upgrade, and repair computer hardware (CPU, Hard Drive, Memory, Modem) and peripherals.
  • Performed database performance tuning activities by conducting routine check of the memory, CPU Logical and physical I/O and contention.
  • Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
  • Designed a new server architecture that lowered overall CPU busy 10% and eliminated thousands of process start-stops per day.
  • Involved heavily in tuning complex user queries with spool out issues, long execution time or high CPU consumption issues.
  • Assembled PC workstation components and configured CPU environments to a predetermined scheme or choose the most appropriate configuration for application.
  • Monitored log space, database growth, error log, disk I/O and CPU utilization for efficient server functioning.
  • Applied quarterly CPU patches to fix vulnerabilities in different versions of Oracle databases as well as upgraded these databases.
  • Monitored log space, database growth, Error Log, Disk I/O, CPU utilization on a regular basis.
  • Advised management in capacity planning in both storage and CPU usage based on historical trends and future needs.
  • Created Performance Baseline Metrics of IO, Paging Space, CPU, Memory, Disk Reads / Writes.
  • Convert MS SQL database application to Oracle with RAC, deploy applications new release with database CPU patches.
  • Involved oracle DB upgrades from 9i-10g, 9i-11g 10g-11g, applied quarterly CPU/PSU patches, fixes whenever released.
  • Monitored SQL Server performance using Windows monitor on CPU, network, physical drive, memory, etc.
  • Detect and troubleshoot SQL server related CPU / memory, I/O, disc space and other resource contention.
  • Worked with the UNIX administration staff to closely monitor such issues as disk space availability and CPU utilization.

Show More

36. ASM

low Demand
Here's how ASM is used in Database Administrator jobs:
  • Analyzed daily activity and provided input to update workload definitions, TASM exceptions and general database related issues.
  • Performed feasibility analysis for Oracle's new ASM feature and provided recommendations to management.
  • Assist in planning and implementing maximum availability and disaster recovery and Installation and Configuration of UNIX/Red Hat Linux, and ASM.
  • Worked on Automatic Storage Management (ASM) for managing data and adding and removing disks from the disk groups.
  • Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles.
  • Migrated the Oracle Database System to 64bit hardware and converted the database storage to an ASM on EMC SAN.
  • Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
  • Converted a 9i EE production database to a 10g SE RAC database with ASM on a two-node cluster.
  • Administered Oracle 10g on HP with active DataGuard and Oracle 10g RAC with ASM on Red Hat Linux.
  • Managed the data migration of 15 Terabytes Epic Clarity Reporting to ASM and architect remote disaster recovery site.
  • Research and setup specific SAN, ASM and DB server hardware (Dell, EMC) for High performance
  • Installed, configured and administered Automatic Storage Management (ASM) on Single instance and RAC instances.
  • Experienced in Implementing Oracle High Availability Solution 10g RAC with ASM and Raw Devices and 10g CRS.
  • Installed, configured and maintained Oracle 11g DB, Real Application Cluster (RAC) with ASM.
  • Monitored free space and added new volumes using raw devices, new ASM disks using ASM.
  • Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
  • Installed and Maintained Oracle 11g RAC Databases, ASM administration, Load balancing and Services administration.
  • Implemented RAC on SUN SOALRIS using ASM for production databases that is running on two-node.
  • Managed 4 nodes Oracle 10g Real Application Clusters (RAC) databases with ASM Storage.
  • Worked with both standard Linux file systems and Oracle Automatic Storage Systems (ASM).

Show More

37. R2

low Demand
Here's how R2 is used in Database Administrator jobs:
  • Administered Multi-Terabyte Oracle 11gR2 databases.
  • Upgraded MS SQL Server 2005 database to MS SQL Server 2008 R2, by using Detach/Attach, Back up & Recovery.
  • Managed high volume databases within a clustered physical/Microsoft Hyper V environment using (SQL Server 2008R2, 2012 & 2014).
  • Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also upgraded from Oracle 10g to 11g.
  • Install, configure, administer and upgrade Oracle Cloud Control 12c, 12cR2, 12cR3 with an Active/Active High Availability configuration.
  • Monitor performance metrics on both SQL Server 2008 R2 Clustered environments (Resident Campuses and Angel, Online Learning environment).
  • Involved in backup and restore of MS-SQL 2000, 2005, 2008R2 databases and creating/syncing users after the database restores.
  • Installed MS SQL Server2008R2 on Win 2008 advanced servers, applied services packs and security fixes in a clustered environment.
  • Maintain, tune and refresh multiple SQL Server 2008 R2 database environments: Development, Test, R12 and Production.
  • Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
  • Designed and implemented additional storage for use with FILESTREAM within SQL Server 2008 R2 for Microsoft SQL server 2008 R2.
  • Provided 24/7 production support for the production databases comprised of SQL 2000, 2005, 2008-R2 and 2012 servers.
  • Worked on 2/3 Node Cluster Environment and Installed SQL Server on Cluster Node in SQL server 2012 and 2008R2.
  • Performed SQL Server 2008 and 2008 r2 version installations along with Oracle Database 10g in Linux and Windows environment.
  • Provide remote database administration support to off-site customers to include troubleshooting SQL Server 2008R2 and SQL Server 2005 issues.
  • Installed new MS SQL Server 2008R2 and maintained 12 servers with total size of the database at 5.1 TB.
  • Participated in the relocation of Oracle database servers (10g R2 and 11g R1) from Ohio to Arkansas.
  • Handled the upgrade of SQL Server 2005 to 2008R2 and worked on applying the Security patches and hot fixes.
  • Cloned number of databases as required and upgraded them from existing Oracle 10g R2 to Oracle 11g R2 versions.
  • Used SQL Server 2008 R2 Management Studio to create, update, and maintain SQL Server Agent jobs.

Show More

38. I/O

low Demand
Here's how I/O is used in Database Administrator jobs:
  • Managed I/O optimization and table-space fragmentation.
  • Analyzed values of performance monitor counters to identify potential disk, I/O subsystem issues and generated reports using PAL tool.
  • Implemented Stripe and Mirror Everything (SAME) methodology to reduce wait times for physical I/O and simplify disk management.
  • Configured named cache and binding objects, proper I/O pools (2k, 4k, and 16k) accordingly.
  • Reorganized table spaces/data files for I/O load balancing, Created Bitmap Indexes & rebuild of Indexes for better performance.
  • Created Buffer Pool objects to cache Database data pages in memory and reduce the physical I/O access to disks.
  • Utilized storage architecture like SAN, RAID, SSD to reduce disk latency and improve I/O performance and redundancy.
  • Check alerts from SQL Log and work with Server team to fix any I/O or operating system issues.
  • Allocated and monitored database space and designed, planned and laid out disk space for well distributed I/O.
  • Enhanced application performance by tuning several database components like shared pool, buffer cache, I/O distribution etc.
  • Increased performance by eliminating contention factors like I/O, buffers, locks, and latches in the database.
  • Experience in Oracle Database performance tuning, SQL query tuning, Instance tuning, I/O tuning.
  • Identified memory pressure and I/O messages in the SQL log and notified Windows administrators to evaluate.
  • Managed disk space, optimized disk I/O, the SGA and also rollback and temporary segments.
  • Implemented best joining techniques to reduce I/O, implemented KEEP buffer pool for frequently used tables.
  • Developed and ran automated quality checks on I/O & FX Databases and coordinated corrections accordingly.
  • Detected and troubleshot I/O errors coming from the production DW server archive log mount point.
  • Worked with storage engineers to spread the data across disk spindles for maximum I/O performance.
  • Allocated database space and hardware I/O, tuned performance of application and database servers.
  • Perform database indexing on a weekly basis, due to high volume of I/O.

Show More

39. Space Management

low Demand
Here's how Space Management is used in Database Administrator jobs:
  • Performed database maintenance, database monitoring and space management to utilize resources efficiently and to improve database performance.
  • Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery.
  • Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
  • Developed and deployed system maintenance procedures to eliminate daily DBA tasks and automated space management reporting.
  • Performed space management, capacity planning, disaster recovery and overall database maintenance.
  • General database operational support included security administration, schema object and space management.
  • Monitored and maintained database space management software and procedures for capacity planning.
  • Performed other regular DBA activities including space management and performance monitoring.
  • Experience in space management, capacity planning for database updates/migration.
  • Assist with database re-organization for better space management and performance.
  • Performed database & system level space management and monitoring.
  • Space management of production and supported Production Oracle databases.
  • Experienced with Space Management and Security.
  • Performed Capacity planning and space management.
  • Space Management using Automatic Storage Management.
  • Performed data recovery from database backup or transaction logs, Database space management, log files and data integrity.
  • Planned and implemented the alert, database maintenance, security policies and space management as per the application requirement.
  • Included backup and recovery, performance tuning, space management, patch support, and support to application developers.
  • Experienced in capacity planning, performance and tuning, space management, database upgrades / migration and data extraction.
  • Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Tables paces and Temporary TS etc.

Show More

40. SAN

low Demand
Here's how SAN is used in Database Administrator jobs:
  • Provided Marketing Department support with proofreading promotional materials, which included a quarterly magazine distributed to several thousand magazine subscribers.
  • Worked closely with development chefs to ensure instructional content accuracy and wrote marketing descriptors for thousands of recipes and ingredients.
  • Configured, Documented and Demonstrated inter node communication between Cassandra nodes and client using SSL encryption.
  • Administered an essential business inventory database containing leasing information for thousands of pagers and mobile radios.
  • Upgraded Exchange 2003 environment utilizing San Storage as a prerequisite of centralizing document scanning systems.
  • Managed Vendor Rationalization initiative that resulted in reducing vendor population from 15 to 4 thousand.
  • Developed quality-control and sanitation procedures in alignment with food-service safety standards for employee training.
  • Maintained healthy environment by establishing, following, and enforcing sanitation standards and procedures
  • Administered several hundred SQL Server instances hosting several thousand production SQL Server databases.
  • Attend SAN Migration meetings to participate in scheduling storage migrations involving oracle Databases.
  • Maintained sanitary work environment consistent with food handling standards.
  • Maintained sanitation standards of utensils for food preparation.
  • Perform database migration to a clustered/SAN server environment.
  • Obtained Iowa Sanitation certificate while employed here.
  • Single Point of Contact for Any SQL Server Needs though out the organization of over thousands of City departments & employees.
  • Perform duties as a Database Administrator for a leader in the insurance industry that services thousands of clients across the nation.
  • Conducted over a thousand online transactions with a near 100% approval rating, with over 1100 combined positive feedback reviews.
  • Implemented many Clustered instances of SQL 2005, 2008 and 2008 R2 (SSAS) Analysis Services in a Production/SAN environment.
  • Innovated working processes by using tools such as Oracle parallel database technology, BMC Patrol, DB Artisan, and SQLBACKTRACK.
  • Performed Migration from a Pyramid Nile SMP server to an 18 node Pyramid RM1000 MPP cluster coupled to an EMC SAN.

Show More

41. Data Migration

low Demand
Here's how Data Migration is used in Database Administrator jobs:
  • Attended various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
  • Developed and performed the data migration application and also developed an application that maintaining the parallel process.
  • Supported MySQL Server database migration related tasks: installation, configuration, data migration and performance tuning.
  • Provided database backups, reorganizations, data migrations, monitoring, security management, and performance support.
  • Provided technical support for development team and data migration for different applications in a heterogeneous environment.
  • Refined data conversion procedures to include audit and accountability for data migration from legacy systems.
  • Developed plans for data strategy, data migration, data quality and database backup/recovery.
  • Administered development database in a large data migration project for Kansas State police department.
  • Performed an additional mini-data migration past go-live date onto test and production environments.
  • Deliver presentations outlining data migration procedures leading to seamless transfer of data.
  • Designed and implemented data migration strategies and led data migration effort.
  • Analyzed data in the legacy application to determine data migration complexity.
  • Performed tuning and designed/delivery of their data migration projects.
  • Performed User-Managed recovery, Logical Backups & Data migration.
  • Tested data migration activities for accuracy and data quality.
  • Completed Data Migration requirements involved in new facility acquisitions.
  • Performed individual data migrations for the different versions.
  • Performed data migration using Oracle Export/Import Utility
  • Handled data migration from different sources
  • Administer annual inter-departmental data migration.

Show More

42. HR

low Demand
Here's how HR is used in Database Administrator jobs:
  • Produced 60% of business through repeats and referrals by providing exceptional customer service and fostering excellent business and customer relationships.
  • Researched software solutions, negotiated purchases and licensing, and managed licensing through consolidation, auditing and documentation of processes.
  • Provided reliable business intelligence to clients through diligent attention to data integrity, management, and understanding of customer requirements.
  • Designed and Implemented Disaster Recovery environments through the use of a variety native and third-party applications/solutions depending on requirement.
  • Provided accounting review and journal entry support for errant project costs discovered through regular internal project reviews.
  • Captured Innocence rekindled creativity within its clients through the use of multimedia content and personal/professional consulting services.
  • Organized three separate yet interdependent development efforts into a single logical project plan maintained in Microsoft Project.
  • Maximized information management efficiency through accurate data entry practices, including regularly performing at above-average productivity levels.
  • Educated and motivated travel agencies and Tour Operator reservation agents through ongoing sales calls and reservations presentations.
  • Installed and configured Content Management System to host reports to increase productivity throughout the company.
  • Developed and maintained relationships with key customer sources through regular contact and follow-up procedures.
  • Solved content integration problems through collaboration with outside vendors and established quality control procedures.
  • Document Control Administrator duties included editing, updating, and issuing procedures through Domino.doc.
  • Implemented Data guard environment between Standby and Primary Database throw Database Configuration Control.
  • Identified and administered security requirements in support of applications through test and production.
  • Analyzed frequently occurring problems and initiated new way to synchronizing data for backup.
  • Prepared graphics for print in magazines and distribution throughout electrical utility community.
  • Developed stored procedures and triggers to enhance performance, through application partitioning.
  • Evaluated HR systems and monitored unemployment claims participating in associated hearings.
  • Managed projects implementing international financial software completely through training clients.

Show More

43. Data Integrity

low Demand
Here's how Data Integrity is used in Database Administrator jobs:
  • Designed physical development databases using Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
  • Provide general oversight of the database, including data integrity, duplicate record management and standardization of data entry.
  • Reviewed physical and logical database design; promote the reliability of database design by ensuring appropriate referential data integrity.
  • Updated systems with current information and ensured high data integrity that minimized opportunity for errors in the end-to-end process.
  • Handled routine backup/data recovery operations and data integrity, ensuring optimal performance for both play and production databases.
  • Developed procedures and implemented testing of databases, correcting errors and making necessary modifications to ensure data integrity.
  • Performed data analysis to determine inconsistent data integrity issues and applied corrective measures to correct data quality.
  • Involved in requirement specification, DB designing of the application, normalization and implementing data integrity rules.
  • Plan and execute database design and administration functions to ensure maximum data integrity, availability and security.
  • Coordinate integration between core applications to automate and improve processes, data integrity, and data consistency.
  • Implement database structures to ensure appropriate levels of performance, data integrity, recovery and security.
  • Maintained back-ups, data integrity, database performance and developed quality control procedures resolved data issues.
  • Provided performance tuning, data integrity and recovery, and troubleshooting for production related application issues.
  • Worked closely with reporting development and testing teams to insure performance and replicated data integrity.
  • Created database maintenance plans that ensured database availability, data integrity, and database consistency.
  • Provided support for systems projects, monitored data integrity, troubleshooting problems with established processes.
  • Managed migrations from old systems to new technology with emphasis on maintaining data integrity.
  • Performed routine data validation, QA and cleanup; data integrity and normalization analysis.
  • Experience in diagnosing and resolving data integrity issues which ensures both consistency and accuracy.
  • Provided analysis of data integrity, user roles/privileges, and creation of support documentation.

Show More

44. AWR

low Demand
Here's how AWR is used in Database Administrator jobs:
  • Analyzed STATSPACK/AWR/ADDM reports for optimization of DB performance periodically.
  • Perform database tuning using AWR report and self-investigation.
  • Performed performance analysis using AWR.
  • Experience in Database performance monitoring, doing analysis on AWR, ADDM, ASH reports, providing recommendations to the developers.
  • Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database.
  • Supported numerous Oracle/SQL Server upgrades, application upgrades, performance related issues via utilizing AWR, ADDM tools and other tools.
  • Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
  • Monitored database growth, created objects, administered users and tuned expensive SQL statements using EXPLAIN PLAN and AWR report.
  • Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
  • Identify poorly performing SQL's through OEM and AWR reports and check the execution plans and optimize those queries.
  • Generated ADDM/AWR reports and analyzed the reports for wait events, time consuming SQL queries and provided tuning recommendations.
  • Tune all SHA and MDOT Oracle databases for peak performance using Dictionary views, AWR, ADDM reports.
  • Involved in database Performance Tuning using AWR/ADDM/ASH on RAC (also including ODA) and NON RAC databases.
  • Provide user training, upgrade validation and system administration tasks * Prepare daily and monthly AWRDS readiness reports.
  • Analyze database activity, perform application database performance and tuning activities using Explain plan, AWR reports etc.
  • Perform Query tuning, Instance/Memory tuning by using various performance tools TK prof, ADDM, AWR reports.
  • Used Oracle database performance and diagnostic packs (AWR/ADDM) to identify and resolve bottleneck in databases.
  • Performed SQL Queries/ Application and Database performance monitoring and tuning using various tools like ADDM, AWR.
  • Use AWR/ADDM for 11g Statistics management & database tuning following creation of new databases and periodically thereafter.
  • Worked extensively on Performance tuning involving the tuning of oracle queries by using AWR, ADDM Reports.

Show More

45. DEV

low Demand
Here's how DEV is used in Database Administrator jobs:
  • Participate with other team members in development and implementation of standard operating procedures, root cause analysis activities and mistake proofing.
  • Coordinated and performed quality assurance testing for movement of database objects from development, acceptance, and production environments.
  • Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
  • Developed and implemented trade funds management and spending performance processes and presented monthly reports to Sales and Senior Management.
  • Develop data base backup/recovery procedures while providing support to business operational models, including 24/7 support when needed.
  • Implemented and maintained connectivity standards for allowing PCs and other devices to communicate with network and server applications.
  • Designed and created Oracle/Unix and Oracle/NT development and production environments to support corporate and operating company application efforts.
  • Supported development and maintenance of complex hierarchical IMS mainframe databases providing business account maintenance and billing functionality.
  • Supervised and assisted database developers and web programmers in query writing, query optimization and performance tuning.
  • Analyzed legacy data structures, developed logical data model, and prepared procedures for legacy data conversion.
  • Promoted to Customer Service Manager position that lead to Web Services Manager, Database Development and Administration.
  • Developed custom monitoring and performance evaluation scripts, providing information on both the database and application statistics.
  • Worked in Agile development environment in the modernization project, guiding development team in successful implementation.
  • Provided Oracle database administration and developer support, installed and configured database and client software.
  • Administered development, QA and production SQL Servers/databases and related systems in a clustered environment.
  • Collaborated with developers, architects, and business stakeholders to create high-performance, cost-effective solutions.
  • Assist developers establishing connection - Provide SQL server databases and Business Objects server administrative support.
  • Developed curriculum for each student in concert with the referring jurisdiction's graduation requirements.
  • Involved in development of scripts to automate backup and recovery procedures for development databases.
  • Developed innovative techniques for expanding prospect base beyond the established, recognized industry standard.

Show More

46. Oltp

low Demand
Here's how Oltp is used in Database Administrator jobs:
  • Led design and implementation of OLTP marketing database for AstraZeneca utilizing Oracle 9.2 security features to protect highly sensitive customer information.
  • Experience in development and implementation of large scale applications involving on-line OLTP and batch environments for various applications.
  • Generated replicated environment for reporting process- reducing the load on OLTP production system.
  • Created and configured an OLTP replication database for disaster recovery purposes.
  • Administered Data Warehousing environments and OLTP applications.
  • Maintained, administered and secured 100+ Microsoft SQL Server databases residing on dozens of development and production OLTP and OLAP servers.
  • Provide day to day support of high OLTP availability databases and technical expertise and guidance to less experienced colleague, users.
  • Participated in technical analysis, database design and Data Modeling using ERWIN tools for OLAP, OLTP ORACEL and MYSQL databases.
  • Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
  • Create, administer, upgrade, and maintain multiple OLTP and Data Warehouse databases containing over one terabyte of total data.
  • Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
  • Provided production support of 450+ Gigabyte database (OLTP) including backup and recovery, performance monitoring/tuning and database maintenance.
  • Designed and implemented OLTP and data warehouse databases used in casinos as a slot accounting and hotel management system.
  • Managed 20+ SQL Servers in production (OLTP and Data Warehouse), from 100GB servers to 500GB servers.
  • Design and implemented the SSIS that extract data from OLTP and insert into Data warehouse and Data Mart.
  • Provide experience and knowledge of designing a Decision Support System (DSS) from OLTP database and transactions.
  • Designed database objects, normalize data base objects using OLTP * Developed stored procedures, functions and triggers.
  • Involved in different scenarios of OLTP as well as OLAP such as DSS (Data Warehousing) Databases.
  • Configure the physical design of the database by implementing a flexible Architecture compliance that suites OLTP databases.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.

Show More

47. ERP

low Demand
Here's how ERP is used in Database Administrator jobs:
  • Implemented MySQL Enterprise Monitor, MySQL Replication Monitor and MySQL Query Analyzer for improving query performance and capacity planning.
  • Assessed Information Assurance Vulnerability Alerts (IAVA) to determine applicability to our database and Enterprise Manager deployments.
  • Displayed strong financial and business acumen including experience in leading managers and interpreting financial reports to drive profitability.
  • Maintained database dictionaries, monitored overall standards and procedures, and integrate enterprise systems through database design.
  • Provided Database training, performance tuning services, in-depth documentation on disaster recovery and Enterprise Replication.
  • Conducted business process workshops with global stakeholder community to establish enterprise and local priorities and requirements.
  • Read, analyzed, and interpreted general business periodicals, technical procedures, or governmental regulations.
  • Provided full life-cycle database support from database development to production management for enterprise IT operations.
  • Created PowerPoint presentations and actively trained developers on query efficiency and database best practices.
  • Collect, analyze and interpret outcome data including standardized measures and behavioral tracking.
  • Performed as Project Manager for ADABAS disaster recovery activity across the Verizon enterprise.
  • Performed daily DBA maintenance activity and monitoring utilizing Enterprise Manager and scripts.
  • Demonstrated best practices and resulting improvements presentations at Caterpillar Oracle User Group.
  • Integrated data from different database sources and provide interpretation and data analysis.
  • Exercised Enterprise Manager for monitoring and managing oracle performance and objects.
  • Placed constraints and security mechanisms to increase Enterprise security and auditing.
  • Maintained and supported enterprise systems and administered Learning Management System.
  • Implemented centralized monitoring utilizing Oracle Enterprise Manager /OEM 10.1 Grid.
  • Created and configured Oracle Enterprise Manager Grid Control Repository Database.
  • Migrated production server from standard edition to Enterprise edition.

Show More

48. Sharepoint

low Demand
Here's how Sharepoint is used in Database Administrator jobs:
  • Implemented SharePoint Portal and Services to provide a document management platform and for future development integration for products.
  • Maintained and managed Oracle content management system and SharePoint website for department to manage and maintain internal information.
  • Streamlined and reorganized the department's SharePoint's file repository enabling team members to locate procedural documents effortlessly.
  • Worked closely with SharePoint and BizTalk teams to ensure proper database maintenance/administration in accordance with those technologies.
  • Gathered SharePoint internal project requirements, designed SharePoint sites/applications and overlooked their implementations.
  • Administered SharePoint server by updating meeting information/agenda, creating new users on SharePoint.
  • Developed a SharePoint based disaster recovery system for state and local governments.
  • Developed and implemented a customer relationship management application using Microsoft SharePoint.
  • Administered users and teams using Microsoft SharePoint with Active Directory.
  • Installed and configured SharePoint 2010 for development and testing environments.
  • Integrated internal business data stored in SharePoint with data warehouse.
  • Maintained architecture for corporate sponsored websites and internal SharePoint intranet.
  • Implemented automated reporting by developing SQL procedures integrated with SharePoint.
  • Implemented a variety of JavaScript solutions inside of SharePoint.
  • Customized solutions using SharePoint Designer and Visual Studio 2010.
  • Provided expertise in Intranet development using SharePoint.
  • Integrated Microsoft Dynamics within the SharePoint environment.
  • Experience in SharePoint service development and configuration.
  • Generated preliminary reports for Microsoft SharePoint 2010.
  • Configured services to optimize SharePoint performance.

Show More

49. Peoplesoft

low Demand
Here's how Peoplesoft is used in Database Administrator jobs:
  • Support PeopleSoft Time & Billing application, including database administration and monitoring, and troubleshooting production issues in a production environment.
  • Developed and monitored system infrastructure and integration between PeopleSoft applications, mainframe, Lotus Notes and other external systems.
  • Support Bank customer/transaction Oracle databases for 24/7 operations by thousands of concurrent users, marketing campaigns and PeopleSoft applications.
  • Work directly with in-house developers on special applications or third party application that interface with PeopleSoft and PeopleTools.
  • Develop a comprehensive understanding of the core functionality offered in various modules of PeopleSoft.
  • Performed configuration management tasks and migrated enhancements to the PeopleSoft applications through Quest Stat.
  • Designed and developed DataStage jobs to extract student curriculum data from PeopleSoft Education Modules.
  • Managed PeopleSoft security, application server, and process scheduler configuration and administration.
  • Performed Oracle database creation, replication and refresh for new/existing PeopleSoft test/upgrade environments.
  • Configured and maintained PeopleSoft production, development and testing databases including database refreshes.
  • Configured and maintained PeopleSoft architecture web, application and process scheduler servers.
  • Configured PeopleSoft Process Scheduler, Report Node Repository and Integration Broker.
  • Created, tested and implemented PeopleSoft database and application disaster/backup/recovery methodology.
  • Documented all PeopleSoft infrastructure components configuration and database refresh procedures.
  • Facilitated global software upgrade and directed expansive PeopleSoft implementation project.
  • Analyze and customize PeopleSoft applications as requested by various departments.
  • Consolidated Oracle/PeopleSoft HCM and FSCM environments into one environment.
  • Cloned/Refreshed PeopleSoft production instance for test and training environments.
  • Involved in setting up PeopleSoft Reporting environment for reporting.
  • Exported and imported PeopleSoft security using Data mover scripts.

Show More

50. User Accounts

low Demand
Here's how User Accounts is used in Database Administrator jobs:
  • Performed diagnostics and troubleshooting of database issues, documented help desk tickets/resolutions, and maintained end-user accounts active and updated.
  • Created user accounts on different databases as required and also managing security issues.
  • Created user accounts and appropriate privileges as well as maintaining database security.
  • Manage database user accounts, including user maintenance and account security.
  • Created and managed user accounts with appropriate privileges and log-in configuration.
  • Created user accounts with appropriate privileges thereby maintaining security.
  • Create user accounts and system-level and user-level database objects.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
  • Created primary database objects (tables, views, and indexes), user accounts, and multiple tables and domains.
  • Analyzed database server performance data, monitored status of the SQL Server Agent jobs, performed user accounts administration, etc.
  • Worked closely with clients in the database development of their company and user accounts and maintained close interaction with them.
  • Create and administer user accounts, roles and rights and ensure security controls and measures are applied to database environments.
  • Create various user accounts for production, training, remote organizations and Criminal Investigation Task Force (CITF).
  • Served as NICE Administrator of Inform, CDIII and NPX applications for all Voice Recording Systems and user accounts.
  • Administered and audited server and user accounts, roles, and privileges to meet company guidelines and standards.
  • Ensured system security with audits of user accounts, log-in locations and cleanup of inactive and sandbox accounts.
  • Managed the relational database and its access rights, creating, modifying, and deleting user accounts.
  • Performed application related DBA tasks such as creating user accounts, roles and took daily application backups.
  • Configured backup and disaster recovery planning, cloning of SAP environments, and processing user accounts.
  • Support user accounts and access privileges, sustaining and clarifying the target security model as needed.

Show More

20 Most Common Skill for a Database Administrator

Database23.2%
Pl/Sql12.6%
Recovery Procedures11.2%
SQL8.3%
Customer Service5.9%
Windows XP5.6%
DBA5.6%
High Availability2.9%

Typical Skill-Sets Required For A Database Administrator

RankSkillPercentage of ResumesPercentage
1
1
Database
Database
18.2%
18.2%
2
2
Pl/Sql
Pl/Sql
9.8%
9.8%
3
3
Recovery Procedures
Recovery Procedures
8.8%
8.8%
4
4
SQL
SQL
6.5%
6.5%
5
5
Customer Service
Customer Service
4.6%
4.6%
6
6
Windows XP
Windows XP
4.4%
4.4%
7
7
DBA
DBA
4.4%
4.4%
8
8
High Availability
High Availability
2.3%
2.3%
9
9
Unix
Unix
2.3%
2.3%
10
10
Setup
Setup
2%
2%
11
11
Linux
Linux
2%
2%
12
12
Rman
Rman
1.8%
1.8%
13
13
Capacity Planning
Capacity Planning
1.8%
1.8%
14
14
Ssis
Ssis
1.6%
1.6%
15
15
Production Environment
Production Environment
1.3%
1.3%
16
16
Solaris
Solaris
1.3%
1.3%
17
17
Troubleshoot
Troubleshoot
1.3%
1.3%
18
18
ETL
ETL
1.3%
1.3%
19
19
RAC
RAC
1.2%
1.2%
20
20
Data Warehouse
Data Warehouse
1.2%
1.2%
21
21
DB2
DB2
1.1%
1.1%
22
22
Ssrs
Ssrs
1%
1%
23
23
T-Sql
T-Sql
1%
1%
24
24
OEM
OEM
1%
1%
25
25
QA
QA
1%
1%
26
26
Sybase
Sybase
0.9%
0.9%
27
27
DTS
DTS
0.9%
0.9%
28
28
AIX
AIX
0.9%
0.9%
29
29
Data Entry
Data Entry
0.9%
0.9%
30
30
Performance Issues
Performance Issues
0.8%
0.8%
31
31
Technical Support
Technical Support
0.8%
0.8%
32
32
Grid
Grid
0.8%
0.8%
33
33
Internet
Internet
0.8%
0.8%
34
34
Toad
Toad
0.7%
0.7%
35
35
CPU
CPU
0.7%
0.7%
36
36
ASM
ASM
0.7%
0.7%
37
37
R2
R2
0.7%
0.7%
38
38
I/O
I/O
0.6%
0.6%
39
39
Space Management
Space Management
0.6%
0.6%
40
40
SAN
SAN
0.6%
0.6%
41
41
Data Migration
Data Migration
0.6%
0.6%
42
42
HR
HR
0.6%
0.6%
43
43
Data Integrity
Data Integrity
0.6%
0.6%
44
44
AWR
AWR
0.5%
0.5%
45
45
DEV
DEV
0.5%
0.5%
46
46
Oltp
Oltp
0.5%
0.5%
47
47
ERP
ERP
0.5%
0.5%
48
48
Sharepoint
Sharepoint
0.5%
0.5%
49
49
Peoplesoft
Peoplesoft
0.5%
0.5%
50
50
User Accounts
User Accounts
0.5%
0.5%

18,639 Database Administrator Jobs

Where do you want to work?