- Featured in:
-
More Database Administrator Resumes
Use these Database Administrator samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Looking for cover letter ideas? See our sample Database Administrator Cover Letter.
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Database Administrator Resume Samples
No results found
0-5 years of experience
Provides database design and management support for all GIS energy projects ranging from thousands to millions in revenue. Improved database application performance by monitoring and tuning databases to optimize storage and minimize server processing.
- Created, documented, and integrated GIS data models and data standards using the base APDM, PODS, and AETM.
- Successfully upgraded SQL Server, ArcSDE, and ArcLicense Manager Applications across multiple servers with minimal production impact.
- Tested, implemented, and supported database replication including both ArcSDE and SQL Server Replication types in an editing environment.
- Solved 85% of all ArcSDE related help desk tickets within a 24-48 hour time span.
- Documented GIS infrastructure information including server type, operating system, DBMS build, and GIS application build.
0-5 years of experience
Senior DB2 database administrator on 3-person team with focal support of Morgan Stanley and General Motors. Backup to 5 other accounts and 200+ databases responsible for all aspects of database support conducting security audits, disaster recovery tests, fixpak upgrades, data migrations, health check remediation, database synchronization.
- Performed problem determination supporting banking terabyte on-demand warehouse environment, capturing connection activity, identifying performance degradation, with end-to-end disciplines represented on every problem call.
- Achieved buffer pool hit ratio tuned above 95%, delivering availability above 99% and 100% customer satisfaction.
- Configured backups and logs to disk and Tivoli Storage Manager (TSM). Improved backup times using TSM disk from 4 hours to under 2 hours.
- Implemented security checks, performed remediation, audit, reports at database level and operating system level for authorized access and product patch advisory notification.
- Dispatched work across team for numerous accounts, providing backup with all aspects of physical / logical design, capacity planning, and performance tuning.
0-5 years of experience
As a member of the DBA Production Control team, responsible for the configuration and administration of Microsoft SQL Server 2000 and 2005 for approximately 50 database servers, and 400+ databases.
- Created, reviewed and implemented maintenance plans on production servers.
- Installed SQL Server 2005 for new servers as well as in-place upgrades to 2005 on 2000 servers.
- Created and maintained documentation for DBA standard operating procedures.
- Supported clustered and non-clustered environments as well as log shipping for disaster recovery.
- Monitored and solved performance issues.
0-5 years of experience
Performed systems testing, functional testing, and regression testing with Motorola Expedience Java Applications running on Apache Tomcat servers with Oracle 9i/10g, Microsoft SQL Server 2000/2005/2008 and Postgres databases.
- Installed, upgraded, and maintained Oracle, MS SQL Server and Postgres databases running in lab environment.
- Configured and administered wired/wireless network consisting of servers, hosts, CPE modems, basestations, and VLAN switches.
- Maintained Expedience and Wimax networks on Linux Redhat, Fedora Core, CentOS, Windows Server 2003, and Windows Server 2008 operating system platforms.
- Performed manual testing and automated testing writing/executing bash shell scripts, Perl scripts, and Selenium scripts against Motorola Expedience Java Applications.
- Wrote and executed test plans for new features and maintained test cases using AP Test, Citrix.
- Verified a certain CPE type will become dysfunctional after performing an upgrade both saved money and time since thousands of these CPE types were currently being used.
0-5 years of experience
Managed a large database for a civil engineering firm with 13 offices throughout New York, New Jersey, and Pennsylvania; served as administrator for a database that tracks and manages employee data including registrations, affiliations, training, certifications, and education.
- Performed extensive follow-up procedures to obtain, update, and validate information; maintained an exceptionally high accuracy rate through data verification, attention to detail, and regular quality control checks.
- Coordinated the migration of project information from an existing system to new database, enabling company to produce proposals and other project-related documentation more efficiently.
- Researched database and performed queries to obtain specific employee-related data for various internal departments.
- Interfaced with software vendor to coordinate the resolution of system problems.
- Prepared Excel spreadsheets to aid in database maintenance.
0-5 years of experience
Provided SQL database Architecture, Design and Maintenance, including Database Creation, Schema Development, Database Migration, Storage Management, System Administration, Database Security, Database Tuning, Database Back Up, Functions, Stored Procedures and Triggers.
- Performed Database Installations, Upgrades and Configurations.
- Created, managed and maintained Data Flow Diagrams, Software and Network Architecture using Visio 97.
- Migrated databases from Access97 to SQL 7. 0.
- Monitored the Transaction activities.
- Provided 24×7 production database support through on call.
- Worked closely with Project Manager, Programmers and Testers to ensure the application meets business requirements.
- Participated in all aspects of Application Software Development Life Cycle.
6-10 years of experience
Lead database administrator providing both administrative and application database services
- Led group of developers in generating web based database applications. Generated SOW, system requirements, design specifications, data modeling, group management and customer liaison.
- Developed and maintained PL/SQL stored procedures, ETL and triggers for various academic web based applications.
- Supported academic end users and senior level management with data report requests.
- Installed and maintained Oracle and Microsoft SQL Server data base instances.
- Provided data modeling and data ETL for all web application development.
- Executed periodic data loads and provided support for various mission critical web based applications.
0-5 years of experience
Increased institutional effectiveness by performing data analysis developing high level reports using SQL and PL/SQL for Office of the Deans and College of Education fulfilling program evaluation and accreditation initiatives. Communicated with internal and external constituents gathering business requirements ensuring feasibility. Increased operational efficiency by implementing Educator Preparation Reform System according to Systems Development Life Cycle.
- Increased service satisfaction by training end users on Business Intelligence reporting software.
- Managed Livetext database by data manipulation, administering accounts, security, passwords ensuring data integrity.
- Modeled historical and trend data for President’s budget forecast analysis, Dean Interview Committee, Alumni Events, Graduation Comparison rates.
- Collected and compiled enrollment data for Online U.S. World News, U.S. World News, Professional Education Data System and Institutional Post-Secondary Data System survey submissions.
6-10 years of experience
Successfully lead a team of four personnel in supporting the Configuration Management, Product Definition, and various other engineering, quality, and manufacturing disciplines, to resolve helpdesk related incidents. Issues associated to resolution of incidents addressed software, data, and customer limitations
- Ensure all incidents submitted are reviewed, researched and resolved per the business processes (a.k.a. standard work instructions) of the Systems Design and Components Integration business unit at Pratt and Whitney.
- Effectively use the ACE (Lean and Six Sigma) operating system tools to eliminate unnecessary spending, identify areas for improvement (team performance), and enhance productivity.
- Provide system level testing and support as required f or new builds/software upgrades to be implemented in the database.
- Used UNIX, Solaris and AIX, to execute utilities provided by the software vendor support group to modify data, and perform basic administrator functions.
- Perform basic project management skills to ensure successful planning and execution of all projects assigned.
0-5 years of experience
Provided day to day support of database applications in multi-tier client server architecture. Provided technical support for Y2K testing initiatives, database upgrades and installations.
- Supplied critical support for initiatives from development through production ensuring stable environment and critical time lines met.
- Provided Technical Support for Y2K initiatives resulting in flawless execution of conversion activities.
- Served as key team member in new product appraisals providing insight for beneficial technologies.
- Presented technical perspective for Enterprise Resource Planning initiatives resulting in seamless architecture approach.
- Orchestrated database installations and upgrades providing operational stability.
0-5 years of experience
Responsible for the development and certification of Property Damage scope for Property Damage claim.
- Lead interface with client Engineering & Estimating teams and insurer’s Engineering & Estimating consultants.
- Responsible for the management and analysis of claim data to quantify value and scope of claim with respect to insurance policy coverage categories and construction estimating standards. This included the creation of ad hoc reports to communicate results of analysis to Project Leaders and client Engineering & Estimating teams.
- Responsible for analyzing, and preparing responses to, data presented by insurance market as part of claim negotiations.
- Maintained and administered an Access database designed to track the value and scope of a large (~$500M) claim.
- Developed, initiated, and managed multiple stage process to track and document client payments to numerous vendors over lifetime of claim.
6-10 years of experience
Developed and supported terabyte database systems for Real Estate and Healthcare applications in multiple developmental test and production environments.
- Supported application teams by building and maintaining robust database infrastructure, utilizing logical and physical data models.
- Provided production support for backup and recovery and participated and supported initiatives for disaster recovery planning, and problem resolution utilizing root cause analysis.
- Identified and administered security requirements in support of applications through test and production.
- Managed projects across multiple server/client configurations.
- Liaison with product software support, as well as external technical support on product upgrades and resolution of problems.
- Participated on change control board overseeing changes to production environment as well as supported TQC corporate wide initiatives.
0-5 years of experience
Administered Oracle 9i and SQL Server 2000 databases. Designed and developed a database for a highly transactional financial application.
- Designed Logical and Physical Data models. Analyzed Use cases. Developed customized ERWIN relational data model for capital calculation (80 entities) and regulatory reporting (50 entities).
- Installed and Created Oracle and SQL Server 2000 Databases on AIX and Windows machines.
- Cloned databases, performed data transfers, managed users, table spaces.
- Developed and optimized SQL Server 2000 database structures, T-SQL stored procedures, views, triggers and user-defined functions in a highly-transactional financial application.
- Tuned SQL & PL/SQL scripts for better performance.
- Developed and implemented a backup and recovery plan for production SQL Server databases.
- Performed SQL Server database imports using Data Transformation Services.
- Scheduled and monitored all maintenance activities of SQL Server including database consistency check, and index defragmentation.
6-10 years of experience
Implemented, upgraded, patched, and supported small to large sized (10 GB to multiple terabytes) Oracle software from 8i to 9i and 10g. These included Oracle Data Guard, UNIX clustered Oracle RAC environments.
- Functioned as the project DBA on a team that implemented and supported NCR Check Imaging application and Lawson payroll application with Oracle software. Provided primary database administration support for a mortgage origination application based on Progress software. Served as backup DBA for the on-line banking application using DB2 UDB software.
- Was the primary DBA for several SqlServer applications (version 7 and 2000)
- Evaluated, installed and maintained various utility software including Oracle OEM, Quest software (I/Watch, Quest Central for Oracle, Quest Central for DB2 UDB, Live Reorg, Spotlight, Space Manager)
- Was a major participant in an Internal audit of Oracle standards, policies, and procedures
- Established and documented disaster recovery strategies for various configurations depending on SLA’s
- Accrued extensive knowledge of Oracle RMAN backup utility as it interfaced with Tivoli Storage Manager software.
0-5 years of experience
Responsible for Oracle 7.3, 8i database administration, installation of Oracle Application Server (Oracle 9iAS, 4.0.8), database replication, backup and recovery, database builds from scratch, application of patches, table design, data modeling, table indexing, import/export, SQL/performance tuning, and database and OS troubleshooting.
- Performed several database administration tasks including SQL tuning, recovery, and backup using RMAN.
- Developed and enhanced various end-user applications using Forms 6i and Reports 6i.
- Created various DSS for end-users consisting of Oracle Discoverer Reports / Brio Query tools.
- Assisted in setting up the Oracle Application Server (9iAS) and Oracle Replication database to enable internet querying of Agency’s data.
0-5 years of experience
Installed and configured database server product (DB2 UDB), performed fixpak upgrades, and applied current patches, and was responsible for backups and restores.
- Supported clustering and replication for DB2 servers and the migration of DB2 Databases
- Perform capacity planning, performance tuning and benchmark testing; monitoring SQL uptime.
- Designed and populated reporting tables, views and stored procedures; configured partitioning for tables with over 300 million rows. (Provide 7 X 24 Support-mission critical DB’s)
- Implemented and maintained database security guidelines and setup permissions.
- Migrated Tablespace containers from raw logical volumes to DMS containers.
- Created federated data sources from DB2 to Oracle databases.
- Utilized UDB DB2 V 8.2, DB2 V 9.1/9.5, AIX 5.2, Sun Solaris, Win2000, KSH, PERL, Win NT, Control Center, Quest Central, Performance Expert, Redbrick 6.3, XML, Toad, SQL*Loader, Linux.
0-5 years of experience
Served as the sole Sybase and SQL Server database administrator and developer for all related projects.
- Planned, oversaw and implemented successful Sybase to SQL Server migration for interdependent mission-critical databases and their front-end client applications.
- Assured query tune-up to optimal performance across T-SQL and MySQL environments.
- Efficiently handled standard DBA tasks such as installation, administration, performance tuning, T-SQL development and support, backup and recovery, replication, maintenance, and upgrades.
- Provided ongoing assistance to the application team with support for an in-house developed trading system.
- Assisted application teams with MySQL administration, troubleshooting and development.
- Devised and implemented and database-driven transaction processing system across replicated database systems.
0-5 years of experience
Provided management assistance on projects where client’s needed custom databases built.
- Researched, designed and implemented a health care database in MS Access to provide insurance company providers updated medical terminology, standard coding for diagnosis, and new updates in the health care industry.
- Created vendor health care checklists to make sure the client was getting exactly what they needed.
- Researched the internet daily to update database regarding new health care-related information and terminology.
- Created all company databases including: Human Resources, Marketing, Consultant Resource
- Schedule, Client Status, Rolodex, etc.
- Managed / tracked monthly employee expenses versus the budget agreed upon by the client – worked with Project Managers when the project went over budget and provided cost savings where needed.
6-10 years of experience
Project management: Technical Oracle consultant for the Compound Management project, requiring coordination with seven AZ sites located in Sweden, U.S. and UK. Received project management award of excellence for this project.
- Enhanced applications: Applied SQLPLUS knowledge to optimize several scientific applications improving performance by several magnitudes.
- Centralized management of information sources: Installed and configured OEM Grid Control to collect metrics on all fifty-four target databases with compliance of over 90%, for proactive management and problem resolution.
- Data security & recoverability: Utilized RMAN repository within OEM Grid Control to backup all production databases in conjunction with service-level-agreements for database recoverability.
- Disaster Recovery: Designed, developed, and deployed the Disaster Recovery (DR) strategy for all business core-critical databases consistent with customer SLA’s.
- Curriculum design: Created an eight week course for IT department and bioinformatics scientists that dealt with Oracle database new features.
6-10 years of experience
Database design and modeling emphasizing on performance, integrity, usability and standardization using Erwin and Embarcadero ER/Studio
- Transformed logical data models into physical models on Microsoft SQL Server 2000/2005/2008
- Provided enterprise level DBA support in a production environment for .NET, JAVA and ColdFusion based applications. Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Environments across enterprise
- Automated custom processes using SSIS/DTS packages to load data from feeds to databases on a daily, weekly or monthly basis. Created DTS/SSIS packages with embedded complex logic using VB/C# scripts. Performed data validation, profiling and cleansing using SSIS.
- Reversed engineered database designs using Erwin and Embarcadero ER/Studio for system re-engineering, future-engineering and documentation
- Migrated DTS packages from MS SQL Server 2000 to MS SQL Server 2005 and 2008 using DTS xChange software
0-5 years of experience
- Made auditing easier and faster by 30% through creating quality control software to store quality control checklists.
- Helped managers to follow up on tasks assigned to people by developing a Task Management System.
- Improved recruitment department’s efficiency by creating an online resume Database.
- Slashed machinery’s maintenance costs 10% by creating a Machinery Damage Computing system.
- Helped managers to be familiar with employees visually by designing company’s Internal Facebook.
- Supported and maintained various information systems including Document Management System, Automation and MS SharePoint 2007.
0-5 years of experience
Designed database tables, views, synonyms, and schema objects in Oracle.
- Created database backup shell scripts, maintained user privileges, and created new user accounts.
- Performed Oracle database tuning and optimizing.
- Audited, recovered, maintained, and resolved problems with the data.
- Converted the existing legacy system to a client-server environment.
- Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export and SQL*Loader.
0-5 years of experience
Primary application support database administrator.
- Performed an electronic conversion, moving ten years of data from AS/400 to an Oracle database.
- Performed database installs and upgrades, analyzed performance issues, setup of user access, sizing and creation of database structures, backup and recovery.
- Acted as Unix System Administrator; created users and group profiles, implemented security, configuration disk storage, installed patches, managed devices, managed virtual and local printer queues, backup and recovery and troubleshooting.
- Wrote SQL scripts and reports. Received new reports specifications daily and extracted the needed data.
- Trained co-workers on the application and troubleshooting. Worked closely with the end users to enhance user interface and creating new functionality.
0-5 years of experience
Supported the General Ledger application migration from VSAM to DB2 z/OS, including program development of custom month end processing job stream. Received ‘Platinum Shield’ and ‘Teamwork at Its Best’ recognition awards for this effort.
- Created and administered data maps that use Informatica PowerCenter and PowerExchange.
- Established data replication utilizing BMC Enterprise Data Propagation.
- Supported and administered the upgrade of IBM Content Manager on Demand V9.
- Planning for DB2 z/OS V11.1 software upgrade.
- Created procedures for DBA team to effectively use BMC Change manager for DB2 schema changes.
0-5 years of experience
Served as Lead Systems and Informix Database Administrator to a team of 4 supporting several versions of Informix application systems running on AIX and Solaris Operating systems.
- Installed and configured over 10 AIX Operating Systems and Informix-Online Dynamic Server environments.
- Led a team of 2 to migrate an Informix database application system to a new IBM RS/6000 server.
- Led the implementation and maintenance of Data Replication Servers using Informix-Online DS on 2 Mission Critical Application Database Systems.
- Implemented a daily/weekly Backup Plan for AIX and Informix using shell scripts. Trained operators on how to perform the backup using menu programs.
- Monitored and maintained multiple Informix instances on 7 IBM machines.
- Provided 100% availability on all Application Systems by monitoring and tracking the health of the entire Informix database system on a daily basis.
- Maintained hundreds of users’ accounts needing access to multiple accounting and financial application systems.
- Involved in the planning, coordinating and implementing of new Informix application systems from test to production, implementation or roll-out.
0-5 years of experience
Designed, implemented, tested, populated and administered the Susquehanna and West Virginia Land OLTP Databases which tracked the ownership of land, surface rights, mineral rights, units, wells and associated energy leases for use in energy development in North Eastern Pennsylvania and West Virginia.
- Created procedures, functions, sequences, constraints and triggers to maintain data integrity. Applied indexes and partitions to improve performance. Created views for monitoring and reporting.
- Designed source to target mapping strategy and performed ETL to populate databases from existing dispirit data sources (text, Excel, Access etc).
- Integrated the Land Databases with the existing Arc GIS system.
- Using Microsoft Visual Studio, developed and implemented a visual basic front end application used for data entry which replaced all previous methods for data storage within the company.
- Created, maintained and monitored logging and archiving system to track user activity allowing for the rollback of erroneous input.
- Reviewed execution plans to optimize query efficiency.
10+ years of experience
Designed and engineered MS SQL solutions including database provisioning, upgrade/patches, database administration automation, backup and recovery including disaster recovery, database standards including database security, database client related software deployment, software certification, database roadmap management, capacity planning, and engineered solution documentations
- Provided consultancy and mentoring for database design, performance tuning, database platform selection for applications, and database related issues
- Coordinated SQL related product training and manage vendor relations for SQL related product licensing
- Supported Oracle production databases in database provisioning, database backup/recovery implementation, database refresh, performance monitoring/tuning, release support, patch analysis and deployment procedure design, review database design, compliance and security audit, and 24×7 on-call support rotation
- Engineered Oracle solutions for standard database administration procedures & database configurations, client distributions, backup/recovery solutions including a special solutions for the large databases, performance monitoring, capacity planning and HA/DR solutions
- Provided consultations and mentoring to Operations dbas
- Managed small projects related to database solution implementation
10+ years of experience
My primary responsibilities were database design, maintenance, security, and back-up the corporate database systems. MS SQL Server 2008, 2005 and Sybase. In twenty five years the company never experienced any material lost of data.
- Moved PowerBuilder code through Serena version control for twelve developers. This kept our application in sync throughout the application life cycle.
- Evaluated user requests for new data elements and systems and incorporated these into the existing shared environment, without any user disruptions.
- Followed security policy to protect company data against internal and external breaches.
- Implemented the design modifications to the database structures to accommodate growth and new business opportunities.
- Proficient in Windows 2008 Server Administration, XP Desktop Admin, IE, Firefox, Windows Office suites.
- Used and the administrator for MySQL PHP open-source Helpdesk solution.
0-5 years of experience
[company name] provides travel assistance to Federal employees through approval, travel arrangements, and expense voucher preparation.
- Installed, configured, and implemented Oracle 9i databases, and provided 24×7 support migrated data from different sources such as XLS, CSV, TXT, XML, and DBF.
- Responsible for managing SQL Server 2000 and Oracle databases and have restructured databases and performed normalization on database tables.
- Reorganized database objects and implemented a Database Growth Plan.
- Performed a database migration from Oracle 9i to Oracle Database 10G.
- Expertise in SQL query tuning by implementing Parallel Execution, query rewriting, Explain Plan, SQL Tracing, optimizing Cost based parameters.
- Implemented the following: automated scripts to performed Database Backups and Logical Backups; new features of Oracle 9i.
- Used SQL* Loader for mass loading of information data and data cleansing; and RDBMS applications and made changes to existing RDBMS applications to maintain high levels of operating standards.
0-5 years of experience
Installed Oracle 10g/11g on Windows/Linux/UNIX.
- Performed data-pump export/import, traditional exports/Imports (cold and hot database backups).
- Created users, and assigning users the appropriate roles as defined by application requirements
- Conducted database performance tuning to ensure acceptable level of performance
- Provided 24×7 on-call production database support
0-5 years of experience
Responsible for IMS and DB2 backup, reorg and recovery jobs, performance monitoring, programmer support, creation and modification of IMS databases and DB2 tables and indexes, and establishing organizational standards.
- Supported mainframe production and development environments for a global materials scheduling and inventory application using both IMS and DB2 database management systems.
- Provided new development support for a global purchasing system using DB2.
- Implemented Year 2000 database enhancements for various General Motors systems.
0-5 years of experience
Communicated rapidly and accurately with U.S Army, Government, and Contract Approved Personnel on software issues and provided instructions on repairing those issues.
- Maintained Government forms and records pertaining to ULLS-A(E).
- Assisted Customers with validation of aircraft historical records.
- Provided installation of ULLS-A(E) related hardware and software.
- Operated independently as my units ULLS-A(E) Database Administrator.
- Created reports on unit capabilities with the ULLS-A(E) system.
- Operated the ULLS-A(E) system while deployed to Afghanistan, resulting in the successful completion of 128 aircraft phases in a nine month period.
0-5 years of experience
Oracle 7.3.4, 8, and 8i Database Administrator on HP UNIX and Windows O/S. Junior Apps DBA on 10.6 Client/Server topology.
- Responsible for all aspects for a 24X7 20 Gigabyte Oracle 7 and 8i Oracle Financials and Payroll database (Version 10) (Security, Tuning, Capacity Planning, Backup and Recovery)
- Developed and implemented Hot, Cold Backups and restore procedures for Oracle on Windows and HP UNIX Databases
- System Administrator: Created Oracle Application users, Set up Concurrent managers, Printers and Performance Tuning. Cloned several database on NT/HP UNIX used for developing and testing of software up, and rdbms upgrades. Upgraded Oracle Databases from 7.3.4 to 8.0 and then 8.0 to 8i.
- Wrote Queries and scripts for to identify problem queries, Invalid objects, poorly tuned SQL statement, (DDL, DML)
0-5 years of experience
Worked on conversion from 8i to 10g on Windows 2000.
- Converted from 8i on IBM NumaQ to 10g on Solaris 10, created RMAN backup scripts.
- Supported eighteen production databases, 24/7.
- Installed 10gAS (9.0.4) on Linux RedHat E.S. 3.0, installed and configured Linux.
6-10 years of experience
Provided 24×7 support for 15 to 20 production process control and manufacturing databases
- Decreased monthly database downturn activities from 16 hours to 30 minutes
- Upgraded databases for both major and minor releases
- Developed packages for use within Cognos and used those packages to create reports
- Designed, created, maintained, and tuned databases in Oracle Rdb, Oracle, and SQL Server
- Helped developers design or improve the performance of queries
- Troubleshot databases when unexpected problems arose
- Provided training to new co-ops, employees, and consultants on SQL, database interface in programs, and SQL programming standards
- Created an archiving methodology which provided almost real-time access to archived records
0-5 years of experience
Responsible for SQL Server database administration including software patch/installations
- Configured SQL 2005 transactional replication from local publisher to remote data center
- Worked with development team on installation and configuration of Wiki tool
- Recommended topology, installed, configured and supported SSRS, SSIS platforms
- Used SQL Profiler and System Monitor to troubleshoot performance issues
0-5 years of experience
- In charge of data migration project for new company-wide Customer Relationship Management (CRM) program with 360+ users. Moved all automated triggers to SQL Server.
- Maintained SQL Server databases – performed operations such as optimizations, backups, standardization, data transformation services (DTS), and data scrubbing.
- Instituted snapshot replication between business sites, created decision-support database to free resources of live database.
- Created users and maintained security, both Windows based and SQL Server based.
0-5 years of experience
Managed client files and client database
- Assembled various tax returns, including federal individual, partnership, and corporation tax returns
- Prepared packages to be couriered, order supplies, and prepare certified mail receipts
- Ensured deadlines were met by maintaining a list of all IRS compliance dates
- Performed clerical duties as required such as maintaining the calender, answering calls
0-5 years of experience
Installed software upgrades, oversight of database backups, monitored DBMS system and disk utilization and database availability
- Performed daily administrative task such as setting up scheduled jobs using oracle scheduler and OEM Grid Control
- Used data pump to migrate data between databases
- Created Oracle instance with appropriate initialization parameters
- Altered, Modified and created Tables, Views and Sequences
- Performing routine database health checks in order to forecast possible issues
- Generate reports and prepare memo to communicate progress and providing early alerts for major updates.
0-5 years of experience
Administrator for SQL Server databases. Wrote applications in Visual Basic to extract and load mainframe cost data for the foundation’s internal billing systems; created Crystal Reports based on these downloads.
- Wrote T-SQL scripts and Stored Procedures to automate database administration.
- Supported foundation with data creation and extraction (ETL) for financial and human resources requirements. Worked with consultants to build a link to State of Virginia accounting and payroll data.
- Wrote Requests for Proposals for external vendor work. Acted as resource during RFP bids and demonstrations.
0-5 years of experience
Handled small Oracle projects and provided Oracle database support. Monitored and optimized database performance, as well as monitored and backed up databases. Enrolled users and maintained system security. Controlled users access to database. Installed Oracle on NT servers and refreshed test databases as needed.
- Played lead role in keeping databases that resided on NT servers up to appropriate Oracle release levels.
- Developed, tested, and implemented 24/7 database availability as a new back-up approach. The back-up approach introduced standby database methodology in conjunction with hot back-ups on NT servers.
- Effectively served as primary support DBA for as many as ten databases.
- Responded to emergency database fixes of production database in a timely manner.
- Followed up with permanent maintenance.
6-10 years of experience
- Managed ETL projects and scripts in migration from mainframe to DB2/SQL Server 2000/SQL Server
- Performed routine client/server application upgrades/installations, created documentation and verification of disaster recovery procedures
- Served as primary database administrator for databases running SQL Server 2000, SQL Server 2005, DB2 and MySQL
- Administered 12 VMware ESX/ESXi hosts with 100+ virtual machines
- Planned and executed regular upgrades of Virtual Infrastructure adding network, storage, and hardware redundancy to ESX hosts
- Managed RHEL and Windows OS on VMware Virtual Machines as well as IBM System X servers
- Virtualized 14+ server Oracle ERP application for upgrade and acceptance testing
0-5 years of experience
As Database Administrator I possess solid analytical skills and am able to apply a moderate level of expertise and some independent judgment to develop solutions to routine problems. I am able to explain technical information to non-technical audiences.
- Data entry and Verification of sensitive material.
- Learned new systems efficiently when/if the need arises.
- Assisted other areas when needed.
- Demonstrated knowledge of the supported/related business areas, and its relationship to the rest of the organization to ensure that the unit systems initiatives meet the needs of the end users and ultimately the clients.
- Maintained accounts with the use our platforms and procedures.
- The ability to identify and escalate any potential issues to management is imperative.
0-5 years of experience
SQL Server Database Administrator responsible for the maintenance of SQL 2000, 2005, and 2008R2 databases.
- High Availability provided by log shipping.
- Maintained daily, weekly and monthly backups through Litespeed.
- Performed configuration and installation of SQL 2008 and 2008R2 databases.
- Performed troubleshooting of databases, including but not limited to security, space requirements and recoverability.
- Served as NICE Administrator of Inform, CDIII and NPX applications for all Voice Recording Systems and user accounts.
- Performed installation and maintenance of CFIII’s CLS and Loggers for the NICE Voice Recorder systems.
- Windows Server Administrator responsible for the maintenance and installation of NICE and Windows servers 2003 and 2008.
0-5 years of experience
Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases on Unix and Windows OS
- Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
- Installed and managed Oracle Enterprise Manager
- Installed and configured relevant network components to ensure database access as well as database consistency and integrity
- Troubleshoot and resolved various oracle connectivity problems.
- Provided network troubleshooting and administrative support for the development staff.
- Installed and managed oracle database using database control
- Created and managed the configuration and support of the Oracle databases
0-5 years of experience
Raiser’s Edge specialist who helped the Department of Development reach its Annual Fund goals in 1996 and 1997.
- Responsible for creation, maintenance and availability of department-wide databases
- Implemented procedures and processes for the dissemination of data
- Provided technical leadership in the selection, implementation and operation of software, computer programs and applications
- Instructed staff on the use of Raiser’s Edge
0-5 years of experience
Responsible for installation and configuration of SQL Server 2012 databases on VM platform.
- Configured Peer-to-Peer Replication between Data Centers.
- Provide 24×7 production support for database and application.
- Maintain SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
- Performance turning, optimization, backup and recovery in SQL Server 2012 environments.
- Created and Configured SQL Server Extended Events to monitor performance bottlenecks.
- Implemented and Maintain Full/Differential/Log backups through Red-Gate Backups.
0-5 years of experience
Oversaw production databases and applications for an enclave of standalone and RAC enterprise systems deployed across Sun Solaris and HP UNIX platforms for our DOD client
- A major assignment entailed migrating Oracle 9i and 10g databases to Oracle 11g. Installed and configured 11g enterprise edition
- Evaluated 11g new features and employed an Oracle 11g Data Guard Environment, using active standby, referenced partition, and secure file architecture
- Accountable for lead on all aspects of the tasks associated with troubleshooting, performance tuning, patching/maintenance, Database hardening, installation documentation, and backup/recovery
- Executed user community, development team, and project service request change control into the QA and Production environments
0-5 years of experience
- Researched and evaluated possible database systems and led migration efforts for existing service bureau database system from SQL Server 2000 to SQL Server 2005.
- Administer database server and web servers for current multi-tier billing application.
- Served as primary system architect and designer of all components for new Windows service-based commercial software application.
0-5 years of experience
Installed, configured, monitored, and supported the following databases: MS SQL Server 2008 instances, Vertica 5.x, MongoDB 2.x, Hadoop for uptime, availability and functionality and ensure SLA’s are met
- Supported multi company products on the Amazon platform including windows, linux, EC2 volumes, EBS snapshots
- Worked with the DBA team to strategize performance metrics, backup and disaster recovery for all databases
- Developed scripts in bash, perl, powershell to automate checking and monitoring the databases
- Coordinated with Dev teams to roll out to production the application new versions, patches
- Owned the operational lifecycle from release to retire (change / problem / incident management)
- Worked alongside Software Developers to design, build and roll out / upgrade new versions
DBA Duties and Responsibilities
No two DBAs are exactly alike, as specific skills vary from employer to employer. However, after analyzing online job postings, we identified several core duties and responsibilities common to the job:
Design and Implement Databases The main responsibility of a DBA is to create new database solutions and implement them properly. They create new databases based on the needs of end users in the company and the overall project requirements.
Monitor Database Performance DBAs monitor overall database performance to ensure end users are receiving the information needed in as little time as possible. If performance is suffering, DBAs identify the problem and promptly fix it.
Run Database Testing After a new database solution is implemented, DBAs run tests on the new solution to ensure it functions correctly before fully rolling it out. Testing involves creating test scenarios to immediately identify and correct problems.
Control Security Access and Permissions DBAs are responsible for controlling all employee access and permissions for accessing their employer’s databases. This often includes verifying access requests and revoking access for employees who have quit or otherwise left the company.
Write and Maintain Documentation Oftentimes, DBAs are responsible for creating and maintaining all database documentation. This includes documenting data policies and procedures as well as data standards.
DBA Skills and Qualifications
Successful DBA candidates have a lot of technical know-how, and they especially know their way around a database. They are highly analytical and pay close attention to everything happening with the databases they manage. Successful candidates also possess the following skills and qualifications:
- Database experience – DBAs know how databases function. This knowledge typically comes through direct experience working with databases, either as an end user or DBA
- SQL knowledge – SQL is a programming language that is essential for managing databases. Successful DBA candidates are well versed in SQL and know how it applies to databases
- IT experience and knowledge – DBA candidates who worked in entry-level IT roles make good fits for this position. Successful DBAs know all about IT and how it affects their employer
- Attention to detail – DBAs are excellent observers, and they can identify database problems with ease. This attention to details helps DBAs optimize database performance
- Teamwork – DBAs often work with a variety of other teams throughout the company, such as the IT department or the coders developing the software. Teamwork skills are essential to ensure the correct information is being communicated
DBA Education and Training
While many employers look to hire DBA candidates who have at least a bachelor’s degree in computer science or a related field, they value experience more than education. If a candidate who doesn’t have a degree can demonstrate their skills through viable experience, they often have a leg up on the competition. Most DBAs will also receive on-the-job training to help them gain the knowledge necessary to fulfill their specific role with a new employer. This training can get them caught up to speed on current databases and any upcoming projects.
DBA Salary and Outlook
According to the Bureau of Labor Statistics (BLS), DBAs make a median annual salary of around $87,000. This salary can vary depending on the industry in which the DBA works, with industries like computer systems and data processing services making the most money – around $95,000 per year. DBAs working in fields like education services can expect to make less than their peers in other industries – around $72,000 per year. DBAs can usually also take part in their employer’s employee benefits plan, which often includes health insurance and paid time off. The BLS reports a faster-than-average growth rate for DBAs at around 11 percent for the next 10 years. This fast growth is driven by the increasing need for more in-depth data in all industries. As the world moves steadily closer to automation, reliable data stored in well-built and well-managed databases is essential.
Helpful Resources
Read through these resources to learn more about the world and role of a DBA:
Database Journal – Database Journal bills itself as “the knowledge center for database professionals.” It includes a featured article section that contains articles specifically about databases and related topics. Some recent articles touch on subjects like tables without clustered indexes and product updates for popular database tools
SQLShack – SQLShack is a simple website that aims to provide clear and concise articles about everything to do with databases. These articles are written by actual database professionals who write on topics like connecting to Azure SQL Database and securing access for SQL Server auditing
Oracle Database Administration Interview Questions You’ll Most Likely Be Asked – this book focuses on interviewing to become a DBA by covering questions you might experience during an interview. You can use this book to brush up on your skills before an interview, or as a helpful resource to find knowledge you might be missing
SQL Guide – this is a four-page laminated pamphlet that you can easily keep on your person or at your desk for quick reference. It covers topics like delimiters/operators, databases, and DML
Data Systems Administration Cover Letter Examples
Rate This Article
Database Administrator
Last edited by: Gabriela Barcenas, CONTENT STRATEGIST -
Gabriela Barcenas
CONTENT STRATEGISTGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
