- Featured in:
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Database Engineer Resume Samples
No results found
6-10 years of experience
Managed and successfully developed Aptare’s Flagship Products – Capacity Manager, Backup Manager and File Analytics. Worked directly with Vice President of Products to recognize and identify potential areas for future business expansion. Owned roadmap and product-managed 6 releases of new product over 2 years – working with 3 scrum teams of 25 engineers spread across 3 global locations.
- Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
- Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
- Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
- Aggressively managed personnel across product development organization. Hired over 10 high-caliber individuals who delivered department objectives and helped exceed sales targets.
- Spent 20% of time in supporting customers in Americas and EMEA and training Aptare’s client services personnel which produced enhanced business results by focusing on delivering great customer satisfaction.
0-5 years of experience
Leading the company’s core revenue generating project and turned it around from a troubled state to a great success generating millions in sales and renewals.
- Optimized the previously existing jobs, stored procedures and views to improve readability and speed.
- Optimized the current databases and took part in re-architecture and redesigning of the database to improve speed of the application.
- Conducted Data research/debugging and assigned task appropriately among team members to ensure timely delivery.
- Optimized, debugged and maintained the daily load SSIS package which loads into our server from different sources.
- Involved in making a proof of concept for 2012 upgrade analyzing all the advantages Vs the effort.
- Initiated and developed a project to check the data integrity of our databases on a weekly basis.
- Worked in highly agile environment closely with business, product owners and QA for successful completion of projects.
6-10 years of experience
Database Engineer for the Enterprise Data Warehouse(EDW) Program fulfilling areas in disaster recovery, database upgrades, and tuning.
- Reduced labor hours by 50% to upgrade Oracle instances from 10g to 11g.
- Prevented company from losing a million dollars daily by ensuring shop floor reports complete before the workday plans finalize.
- Empowered company to receive their Joint Strike Fighter Contract Award Fee by releasing a metrics tool on schedule.
6-10 years of experience
Ensured timely delivery of business-critical data. Improved data warehouse environment through creation of database conventions and standards documents for production and development on Teradata and Netezza RDBMS.
- Designed and developed multiple RDBMS platform migrations, and developed programs and scripts.
- Mentored staff to optimize complex queries and data movements, and report inefficiencies.
- Managed backup / restore, bulk data loading, system monitoring, and performance tuning.
- Developed and implemented DDL, DCL, and DML within Teradata best practices.
- Performed data modeling in 3rd Normal and Dimensional forms.
- Spearheaded team evaluating Netezza.
0-5 years of experience
Designed and implemented SSIS packages transfer manipulate data across databases. These packages included complex data transformations utilizing the entire SSIS toolbox.
- Designed and implemented SSIS package to import and export data to and from files in various f ormats.
- Implemented and maintained data testing suite for the data portions of our applications.
- Maintained and updated legacy data importing and exporting applications. Tuned and streamlined existing ETL applications.
- Created application facing stored procedures, views and functions.
- Performed extensive query tuning using SQL Profiler to contribute to key application performance indicators.
- Designed and maintained complex reports in SSRS.
0-5 years of experience
Provided guidance on feature development and facilitated cross scrum-team communication. Daily responsibilities included recommending and implementing product improvements, database development and design, performance tuning, and preparing and performing database deployments between environments.
- Architected and implemented the database backend for a RabbitMQ/MSSQL process for the asynchronous tracking of inventory activity per marketplace
- Reduced database CPU and IO by greater than 20%, improving data accuracy, and eliminating delay for customer access to aggregate data
- Designed and developed a custom sharding solution encompassing hundreds of shards across a farm of SQL Servers
6-10 years of experience
[company name] is a leading global provider of content-enabled workflow solutions designed specifically for professionals in the legal, corporate, accounting, and academic markets.
- Designed, developed and implemented new database objects including tables, indexes, triggers, functions and stored procedures used by the InterAction CRM product for the SQL Server database platform. Assisted the development team in modifying the data model used by the software applications.
- Assisted in the development of the Content Subscription module, and in the conversion of the Total Match module – both meant to feed data to the InterAction system.
- Documented and diagrammed the entire data model used by the InterAction product.
- Provided assistance to the support team helping them resolve customer issues.
- Assisted the quality assurance department with the testing of various portions of the InterAction product.
0-5 years of experience
Primary developer within the database group of Enron Broadband Switching Systems: design, implementation, integration testing, and maintenance.
- Developed an ODBC program that allows the dynamic provisioning of new pooling points to support Enron’s switching network.
- Designed and developed Oracle Pro*C program that collects switch metric performance data (in XML format) in order to support Enron’s bandwidth trading functions.
- Helped architect, design, and code an application that provides email notification of active connections for bandwidth on demand service.
- Worked on and enhanced an XA compliant database transaction processing manager.
- Supported and wrote code for billing system using C/C++, T-SQL, and PL/SQL.
- Wrote various Database API functions that are used by graph services and switching groups.
- Served as backup DBA for Oracle databases and SQL Server databases.
10+ years of experience
Responsible for the maintenance of Quality databases, data analysis, and Quality metrics reporting.
- Maintained and upgraded databases that collect and analyze data for Quality Trends, Factory Yields, Supplier Quality, Defect Paretos, and Nonconformance data, to ensure compliance with company quality standards.
- Supported Quality Improvement and Warranty reduction team activities by providing detailed data analysis.
- Interface with and extract data from other company databases (ERP, PDM, etc.) to support Quality analysis and reporting.
- Trained and supported users with inputting data and creating reports.
- Work with Director of Quality and Senior Manager of Corporate IT to assure interface with other company systems, compliance with ISO requirements, and to plan for future features and storage requirements.
- Project Manager for upgrades to Operations department mission critical software. Managed and scheduled all budget and contractor issues.
0-5 years of experience
Supported local and remote databases for DoD JEIDDO (Joint Improvised Explosive Devise Defeat Organization).
- Administered Oracle servers using OEM (Oracle Enterprise Manager) on Linux and Windows platforms.
- Created and maintained multi-master replication as a solution for failover and load-balancing issues.
- Installed and configured Oracle databases and Oracle Secure Enterprise Search, including the addition of new schedules and table search.
- Upgraded Oracle version and patch quarterly.
- Restored data from data pump export or template before sending to Afghanistan and Iraq.
0-5 years of experience
Managed and maintained SQL Servers databases at a maximum size of 5TB to 10TB, with in 4 main production environments; participated in on-Call schedules. Provided expert technical database management and support in the definition, design, creation, and maintenance of production, Unit testing, and maintain database.
- Wrote ETL loads, customized extracts and reports for clients such as apple, HRB, etc, using SSIS, SSRS, based on request.
- Designed and Deployed SSIS packages to integrate data from disparate system databases and files.
- Designed and Deployed SSRS reports using user requirements and System team needs.
- Designed OLAP cubes to be used by SSRS reports.
- Installed and configured SQL Server 2008 and Reporting Services on Windows Servers.
- Worked with Systems and Programming team and project managers to manage project schedules and priorities related database development, production and application implementation.
- Advised application development staff and users on database solutions to business problems. Performed routine data backups and restore procedures, data refresh, database and performance tuning as well as assisting the development staff with SQL tuning.
0-5 years of experience
- Developed Python and Perl scripts for extracting, transforming and loading (ETL) website traffic log files into MySQL databases on Red Hat Linux.
- Created Microsoft SQL and Oracle 8i test environments on Windows 2000.
- Performed audits to ensure data integrity.
- Improved existing Python scripts to improve large data transfers between Unix and Solaris servers.
- Scheduled shell scripts to monitor disk space and send email notifications using cron job.
0-5 years of experience
Public Company; 10,001+ employees; VZ; Telecommunications industry
- Designed, Developed and implemented Oracle 8i databases for mission critical system by decommissioning a 3rd part product thus saved huge maintenance costs.
- Effectively used data modeling tools, Erwin and BMC Change Manager and centralized all database changes to implement into production systems.
- Extensively used Shareplex replication for data replication to provide high availability and disaster recover ability.
0-5 years of experience
Unisys developed for the Internal Revenue Service (IRS) a new Excise Tax Information System (EXTIS) to replace an older system as part of a software development life cycle (SDLC) project.
- Translated business requirements into relational entity model. Converted logical models into physical models and designed data structures while applying normalization techniques and user access requirements.
- Reverse-engineered databases to provide test, development, and pre-production environments for application developers and testers.
- Documented database design, data definition language, defined data migration strategy between different products/versions and developed data migration procedures.
- Actively participated in user-training classes with application developers.
6-10 years of experience
Database consultant to Switching Software development teams spanning numerous organizations and projects.
- Expert knowledge of relational databases and data design principals.
- Provided added value to features by designing and engineering client database relations.
- Headed memory-mining efforts during postmortem of each software release.
- Authored Data Design documents and served as database consultant for major ISDN and OSPS features.
- Streamlined data design process resulting in reduction of development intervals and costs.
0-5 years of experience
Create and maintain a development and production database.
- Involvement with architecture, database development, administration, and analysis on an a Oracle 11g database.
- Designed, developed, built, analyzed database management systems to include database modeling and design, relational database architecture, metadata and repository creation and configuration management.
- Used data mapping, data mining and data transformational analysis tools such as ERWIN and TOAD to design and develop databases.
- Provided day to day task and direction to junior database engineers in support of organizational projects
0-5 years of experience
Designed logical and physical model of OLTP database using ER-Win and later forward engineered the physical model to Microsoft SQL server 2008
- Created UML Diagrams – Activity diagrams and sequence diagrams using Microsoft Visio.
- Create requirement enhancements document and scope document for modeling integration and data models
- Create Entity Relationship Diagram (ERD) to communication and clarify the physical data models for Subject Matter Expert and developers.
- Assisted in designing both the relational data warehouse and the staging database ensuring the quality and consistency of the data in both repositories.
- Designed and implemented ETL strategies using various transformations like Lookup, Fuzzy grouping, Merge, SCD, Audit , Rowcount,etc,.
0-5 years of experience
Provide Support to existing services by developing complex TSQL Scripts and rewriting the Old legacy Code in a better way
- Created different Reports Using SSRS which would be used by the OPS team for getting alerts, monitoring systems and Capacity planning purposes
- Looking into new reporting framework like (Qlik), to make sure how this can be introduced into the current environment and can be used to replace SSRS(Static reporting Framework)
- Developed reports Like Chi square test and Index/Merge Throughput reports which were used for internal purposes to determine the effect of code and hardware on the current system.
- Initiated the process of source/version controlling the Databases which helps in keeping track of changes and working towards implementation of CI process.
0-5 years of experience
Created and maintained standard proforma models for multiple product types and mixed-use applications
- Participated in strategic planning processes, gathering economic information, production of investment packages
- Reviewed and abstracted legal documents: Leases, Operating Agreements, Purchase and Sale Agreements
- Provided resources and assistance in financial analysis and forecasts for current and prospective projects
- Engineered, built and maintained innovative database systems for internal and external applications
0-5 years of experience
Created and developed functional and detailed specifications for user customizations
- Created, modified and updated packages, stored procedures and database triggers, used PL/SQL and Unix/DOS shell script and PowerBuilder
- Automated calculations to manage all types of complex labor union and non-union environments from 250 to over 100,000 employees were cost-effectively implemented:
- Advised developers on issues of query optimization, index utilization, coding standards and best practices
- Created customized upgrades and fixes for clients, optimized and tuned server SRTrans process between SmartTime and SmartRules for complex payroll, labor, and HR benefits calculations
- Coordinated and configured software upgrades/installations for database and applications
- Created instances, performed tuning, backups and troubleshooting for clients
- Provided Oracle database administration support to clients, QA and development teams
- Evaluated software and hardware technology and advised on tools, methods and alternative solutions
0-5 years of experience
Built and maintained a number of large databases containing information from various Multiple Listing Services (MLS’s) across the country.
- Created and managed ETL processes to regularly import and update listing data from the MLS’s.
- Charged with monitoring over 100 processes, making sure that each ran successfully, and correcting any errors found.
- Wrote stored procedures to convert the data into different formats (e.g. XML, CSV, pipe-delimited text file) required by the specifications of each company.
- Created processes to run stored procedures and export data nightly.
- Responded to clients in a timely manner and provided regular updates to keep them aware of the problem solving process.
- Applied extra effort to make sure to examine and eliminate the cause in addition to the symptom of the issue.
- Occasionally placed in charge of assigning problems to team members, and reviewing all submitted solutions for accuracy and completeness.
0-5 years of experience
Provided migration of the database from Javalen to Aderant accounting systems.
- Designed complex stored procedures for new accounting system and updated tables with missing information.
- Reconnected database structure of the old accounting system to the new one.
- Tested translated procedures to ensure reports providing correct data for accounting needs.
0-5 years of experience
Provided migration of the database from Javalen to Aderant accounting systems.
- Designed complex stored procedures for new accounting system and updated tables with missing information.
- Reconnected database structure of the old accounting system to the new one.
- Tested translated procedures to ensure reports providing correct data for accounting needs.
0-5 years of experience
Analyze large sets of complex data from federal government and military sources in preparation for conversion and translation into usable communications and computer data products
- Maintain communications with government customers, regarding requirements, scheduling coordination, technical discussions and tasks as well as concerns, issues and future solutions
- Work closely with database team leads and subject matter experts to shorten timelines and minimize costs to the customers by implementing stringent process measures ensuring standards were exceeded
- Develop, implement and maintain quality assurance methodologies to sustain data product accuracy rate of 99.98%
- Work closely with the Program Manager and contract proposal staff to develop staffing plans, cost models and work flow diagrams during contract negotiations
- Create and sustain business rules and processes to ensure complete and successful product delivery ahead of expected delivery dates
- Trouble shoot and test data systems to establish streamlined database building tools that result in shorter build and turn over time with an acceptable customer rating of 95%
0-5 years of experience
- Developed a web application to store and display Enterprise database backup information using Perl and 4GL that added robustness to disaster recovery strategy
- Led Enterprise application Production Archive Database failover project decreasing emergency failover time from 7 to 5 hours
- Built a full-fledged Enterprise Beta environment for development testing to prevent Production outages
- Constructed maintenance scripts in SQL/Bash to manage MySQL backups and Replication to support Hadoop Hive and WordPress
- Provided database monitoring during application load tests and analyzed performance data for new feature evaluation
- Participated in Schema Design for OLTP systems to support rapid application development
- Constructed tests and analyzed results for database server evaluation between Sun T5 and M5000 server
- Automated schema change processes and reduced Unix shell script code base by 20%
0-5 years of experience
Initiated communications and responsibly communicated with clients for receiving accurate POS data
- Performed projects and delivered data using MySQL queries and Python scripts
- Defined documentation standards and maintained documentation of every important process
- Executed projects single-handedly for retailers like Safeway, Food Lion, Kroger, etc. as well as CPGs
- Project Lead for carrying out Back-ups and Archival of DB servers on a schedule
- Analyzing the POS data with Tableau to investigate trends, patterns and creating reports
6-10 years of experience
Design and development database processing tools to process NL4/NL5/NL6 vehicle navigation databases.
System: Windows XP, 7. Knowledge: MSSQL Server 2008R2, Oracle 10g, SDAL navigation database, Navteq POIs.
- Saved 96% of vehicle navigation database production time by refactoring the processing procedures.
- Designed and implemented new vehicle navigation database in relational module.
- Produce vehicle navigation database (SDAL map with POIs) every quarter.
- Produce Hertz Airport Return/Hertz Local Editions database as needed.
- Produce Segment Exclude database to redirect customer routes as needed.
- Produce Vicinity Lock database to collect rental vehicles in-bounding and out-bounding information.
0-5 years of experience
Multi-Media Web Development/Electronic Commerce
- Logically and physically modeled, designed, implemented, and maintained Oracle database solutions for e-commerce sites.
- Designed and developed procedural database access for a three-tier environment.
- Implemented security standards for web access.
0-5 years of experience
Designed, built, and maintain a relational SQL Server database with full referential integrity to track [company name].’s internal clients, contacts, and prospects.
- Built and manage a front-end interface designed to allow users to easily access and manipulate data.
- Analyze large data sets using Hadoop framework and Tableau; draw conclusions and make recommendations to clients as well as internal business units.
- Developed predictive CRM model to aid consulting teams in discovering and retaining contacts during email campaigns.
- Developed ETL, data cleansing, and data uploading processes using SSIS to streamline daily tasks.
- Managed US companywide rollout of new database system, which included testing, training, configuring, tuning and patching in five US offices with a two-week time frame.
- Daily exposure to SQL Server/T-SQL querying including stored procedures, triggers, and sub queries.
6-10 years of experience
Engineering lead on a cross-functional team to invent the Delivery Expert System (sm), an automated delivery system that handles message delivery with build in human intelligence. This system has improved the service efficiency by 80% and reduced the service cost by nine million run rate per year. System developed in Pro*C and Neuron Data – Nexpert Elements system.
- Worked with end users to develop and refine business requirements for projects.
- Utilized Structured Methodologies to design Database systems and applications.
- Utilized project planning tools to plan and lead development process.
- Provided technical support and leadership to developers and analysts.
- Managed a group of 2 to 7 developers and analysts.
- Performance tuning of Oracle Applications and scripts.
- Supported and maintained all Core software.
0-5 years of experience
Responsible for modifying database structure while ensuring integrity, stability, and system availability.
- Provided performance managing problem solving skills in monitoring back end database interfaces.
- Facilitated enterprise-level ETL requests and Executed ad hoc reports with accessibility to live data.
- Published Supply Chain Sales and Open Orders pivot reports to US&C and LAR on SharePoint.
- Tested database design and functionality, tuning, systems performance and trouble shooting.
- Measured viability and costs assessment of SQL financials input via web interface prototype.
- Scheduled SAP ETL interfaces for population of RDBMS-Global Data Warehouse tables.
- Provided data normalization scripting, consolidation and streamlined employee tasks.
- Designed VB/ASP.NET intranet applications for data entry with Pivot reporting GUI.
- Developed and implemented systematic Access database ETL processing of SAP data.
- Provided third level desktop support for integration and configuration of MS Office 2007 for compatibility with Access database applications ODBC linked Pivots to proprietary tables.
0-5 years of experience
Maintained and expanded database of international economic data using FAME
- Created dashboard using SQL and Macros for client instant messaging service
- Supervised summer interns in expanding client mapping capabilities
- Gained proficiency in standard classification systems (ISIC, BPM6, NAICS, SNA etc.)
- Managed banking data acquisition project for client
0-5 years of experience
Sole database developer for Blunderbuss, an online PvP game.
- Designed and developed the data architecture for a shard-less, persistent online game and the associated platform, including player registration, commerce functionality, customer service tools, and long-term analytical tools.
- Created and managed the development pipeline for all database-related functionality and code, from initial design to final deployment and ongoing maintenance.
- Designed a warehouse-based analytical system to track player activity and game balance statistics.
- MS SQL Server, Python, BI Development
0-5 years of experience
Performed daily tasks including backup and restore
- Created tables, views, triggers, stored procedures and performed data imports and restores for successful migration
- Executes test cases/test scripts for various applications
- Provided Tier 1/ Tier 2 level help desk support via phone, email, teleconference, or remote access
- Diagnosed and resolved end-user printer, e-mail, Internet, and local-area network access issues.
- Utilized Remedy ticketing system to track and manage technical support.
- Supervised the setup, maintenance & troubleshooting of hardware.
- Manage Help Desk team and perform duties in a cost-effective manner to avoid waste of resources without jeopardizing quality of care and service.
6-10 years of experience
- Provided primary support for team’s largest client. Supported SQL Server database servers in several environments previously supported by client employees.
- Coordinated team activities with multiple groups supporting [company name]’ clients.
- Participated in client disaster recovery drills.
- Gathered information regarding clients’ databases for Sarbanes-Oxley compliance.
0-5 years of experience
Leading Healthcare Imaging and IT Company.
- Implemented enhancements to Universal Manager – radiology office management system. C++, Sybase, SQL.
- Enhanced and maintained various database management tools. C++, Sybase, SQL.
- Performed multiple database-related tasks, such as schema upgrades, database backups, data migration, data cleaning, performance tuning, etc. Sybase, SQL
- Promptly resolved customers’ database issues. Sybase, SQL.
0-5 years of experience
Designed and modeled entire database for management of sporting events
- Developed ETL processes (SSIS, SQL scripts, etc.) to load data from old Access database to new SQL Server database
- Installed and configured database server
- Performed routine database maintenance, security administration, and user administration
6-10 years of experience
Developed Topscene, Med-S, and CDB databases
- Delegated tasking to others when lead on a project
- Assisted in creating “how-to” guides for new developers
- Participated in mentoring and training new personnel on various software applications such as Topscene, Creator, ArcGIS, and the creations of Med-S and CDB databases
- Edited vector data and manipulated imagery
- Gathered information concerning the capabilities of company products; investigated the technical capabilities of company products and competing equipment; stays abreast of development in hardware and software; analyzed customer problems; assisted in designing systems to satisfy customer needs
- Provided a level of post-sales support and service to customer’s sites and remote sites at a high tech level that cannot be rendered by the basic level of field hardware and systems software service. Employee is usually introduced to the customer site when the nature of equipment service required is beyond the skill level possessed by the basic field\customer service engineer
- Provided 24/7, 365 day mission support to Special Operations Unit
- Provided database support for simulator development and training to a Special Operations Unit
0-5 years of experience
Work on a team that is at the core of the company’s web and excel platforms; daily tasks and projects require both business and technical expertise.
- Manage the backend caching server responsible for the generation of API cache tables.
- Worked on development environment team responsible for the SQL platform.
- Implemented and supported performance tuning efforts.
- Consolidated bloated queries to be manageable and efficient.
- Investigate and repair issues associated with updating legacy systems to current gen.
- Worked across teams to implement conversion metrics for an internal client.
0-5 years of experience
Supported and managed the US-VISIT (Department of Homeland Security) Enterprise Reporting System Oracle 10g database schema release using CVS and Version Manager.
- Worked and troubleshot issues with Advanced Queue (AQ) and automated a Metalink internal note to resolve known AQ orphan objects using PL/SQL.
- Developed scripts in PL/SQL, UNIX shell scripts to facilitate database management.
- Analyzed data, performed code reviews and identified architectural issues by enforcing integrity relationships in the source tables instead of Materialized Views.
- Performed SQL tuning using Explain Plan and suggested query rewrite, using hints and create of indexes to eliminate Full Table Scans.
- Worked with Oracle schedulers
- Worked with release documentation.
- Responded to ad-hoc database requests and resolved various database issues.
0-5 years of experience
Technologies: RDBMS (Oracle V7), Graphical User Interface Tools – GUI (Oracle Developer/2000 – Forms, Reports, Graphics), Case Tools (Cadre Teamwork), SQL, SQL*Plus, PL/SQL, Embedded SQL (Pro*Ada, Pro*C), SQL*Loader, Unix (DEC)
- Designed and developed database system used in a ground satellite equipment trainer
- Designed and developed GUI for an Instructor Operator Station used for classroom monitoring, student performance monitoring, and administration of student record data
- Designed and developed code to provide a programmatic interface to the database for recording of student scoring and performance data
0-5 years of experience
- Created functional/technical design documentation for the CV data warehouse conversion project. Presented requirements and conversion strategy to upper management for approval.
- Utilizing Oracle9i PL/SQL and Unix shell scripting on Solaris8, developed and implemented data warehouse conversion process for the CV Marketing Campaign and Item/Product marts.
- Designed and developed Informatica mappings/sessions/workflows for CV Legacy Registration/Rebate process.
- Application DBA support involving SQL optimization, development/QA staff assistance on Oracle concepts, creating DDL consolidation and release procedures, and Erwin data modeling/reporting.
0-5 years of experience
Involved in the Design Development and Maintenance of Business Partner Advantage Program (BPAP) and International Compensation Calculator (ICC).
- Redesigned and Implemented the BPAP System so the Business Partners of Avaya can directly input the Sales data into the BPAP system. This involved Redesigning the Oracle Database and programming in PERL-CGI, Unix Shell scripts. Written Stored Procedures, Triggers and Packages using PL/SQL.
- Designed and Implemented a Data Mart, with ETL processes using Stored Procedures (PL/SQL), PERL and Unix Shell scripts.
- Written Packages in PERL, and Unix Shell scripts (Korn, Bash) for the weekly and daily data feeds and Cron jobs.
- Implemented the Object Oriented methodologies and Regular Expressions to enable reusability of the PERL packages across multiple projects to make the applications robust.
- Installed and Configured the Oracle database for the ICC project. Designed the logical and physical Database for Test and Production Environments.
- Written Oracle PL/SQL Procedures, Triggers and scripts in PERL and Unix Shell to massage and load the data into the ICC system from the legacy (Mainframe) system. Also used SQL*Loader to load the data.
0-5 years of experience
Validate security architectures to meet established baseline requirements; identify deficiencies and recommend mitigations/countermeasures.
- Develop, publish, and maintain validation documentation and development artifacts
- Reset passwords using Active Directory, troubleshoot network connections, and handle other related trouble calls related to connectivity and security.
- Supervised SOX audits in areas of databases and software development.
- Decision maker in business continuity planning and disaster recovery planning teams
- Contributor in risk management activities
- Performed upgrades, patch maintenance and integration with vendor software on Windows platforms.
- Designed and maintained of Database environment at [company name] Periodical Fulfillment division, a $2 billion dollar media company.
- Supported a distributed SQL Server and Oracle database environment
- Served as technical project lead for database server consolidation project, collapsing several database servers to virtual environments using VMware and blade servers.
- Created business continuity solutions for SQL Servers using asynchronous database mirroring from the Fort Myers, FL facility to the warm site in Kentucky
6-10 years of experience
Designed and implemented database and other software solutions for in house as well as external production environments
- Created and automated systems for creating location specific database installations
- Used a variety of computer languages which included C#, Python, C, and C++ to develop software
- Prepared and presented technical classes
- Transitioned from waterfall to other more agile methodologies including Kanban and Scrum
0-5 years of experience
Served as the development DBA with many production DBA responsibilities
- Lead the effort to scale one of our clients form 50 to 30,000 users with a 4 Node RAC cluster
- Installed a 2 Node RAC cluster in development on Solaris using Oracle 9.2
- Absolute end of the line for all performance tuning issues
- Wrote batch ingestion scripts (ETL) in Korn Shell and PL/SQL that published up to 200 Gigabytes/night.
- Perform development database administration including logical/physical design, table space management, SQL and instance tuning, and back end development
0-5 years of experience
Designed, developed and maintained 100+ legacy Data interfaces for loading Authorizations, Member Eligibility and
Encounters and Prescriber data based on HIPAA 5010 standards.
- Installed Hadoop ecosystem components in a pseudo-distributed mode using Rackspace Cloud.
- Processed large sets of structured, semi-structured and unstructured data using Hive.
- Customized ETL development using a combination of SQL code, Java and Python.
- Collaborated with key stakeholders and Trading Partners to define requirements and document Technical Design
0-5 years of experience
DBA border security Enterprise Campaign for e-Borders program for UK Ministry of Defence.
- Assisted in Oracle 10G RAC administration and configuration on Red Hat Linux
- Used HammerOra to stress test mission critical e-borders use cases and transactions
- Installed and assisted in administration of Oracle Designer
- Worked with Data Architects in designing of abstract, logical, and physical generation of 3NF database application schema
- Assisted in configuring Hibernate, mapping, and generating Java source files from application schema including installation of Hibernate, Ant, and Oracle JDBC drivers
- Used RunStats package to benchmark BULK COLLECT/BIND as well as general use of BEFORE triggers versus Hibernate sequence and timestamp generation on INSERT or UPDATE
0-5 years of experience
- Responsible for analysis, design, development, deployment of Oracle PL/SQL API layer.
- Analyzed in depth vendors and financial / collection systems of FEMA agency.
- Analyzed and traced the flow of events in the executable of FEMA manual processes.
- Developed models, algorithms and processes of assessment of a probability of a fraud in financial / collection system in data distribution between participants.
- Created use cases of automation processes for FEMA financial system participants.
- Implemented processes of exchanging set of flat files and XML files between Oracle and FTP servers with loading and update data in Oracle Database 10g.
0-5 years of experience
Monster Worldwide, Inc. (Monster.com) provides global online employment solutions. With a presence in approximately 55 countries globally, including key markets in North America, Europe, Asia and Latin America, Monster offers online recruiting solutions.
- Worked on the back-end of the core Monster.com website performing Database and ETL Development
- Played a major role in improving the way the core Monster.com site processes job seeker applications.
- Played a major role in creating a Fraud and Compliance reporting solution.
- Proven ability to quickly diagnose and fix production issues
- Ability to quickly and adequately pin-point issues or problems and devise solutions
- Team lead for 2 development releases
Database Engineer Duties and Responsibilities
Specific day-to-day job duties for database engineers vary based on employer. However, the core duties for database engineers are the same across all companies:
Write and Maintain Database Programs Database engineers write new database programs and maintain existing programs to ensure they can handle the flow of traffic and the amount of data being stored in the database.
Design New Databases Database engineers design new databases based on company needs, data storage needs, and the number of users accessing the database.
Monitor Databases and Programs Database engineers continuously monitor databases and related systems to ensure high functionality.
Write Programs and Scripts Database engineers write new support programs and scripts for databases to increase data storage capacity and fix existing database problems.
Troubleshooting Database engineers troubleshoot database code, checking for potential problems that affect database functionality and related database programs.
Debugging Database engineers look through coding language to debug existing database scripts and programs.
Review Database Reports Database engineers review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working at peak levels.
Database Engineer Skills and Qualifications
Database engineers know a variety of computer programming languages and work quickly to spot and solve problems. Employers look for database engineers who possess the necessary skills needed to perform all aspects of the job:
- Computer coding – database engineers write and review computer codes to design high-functioning database systems, support programs, and to debug systems
- Problem-solving – database engineers look for potential problems in the database, and work to solve these issues before and after they occur
- Attention to detail – to comb through lines of code to spot potential error-causing problems and possible database security and storage capacity issues
- Programming languages – database engineers know how to write in several common programming languages, including Python and Java
Database Engineer Education and Training
Employers require database engineers to have a bachelor’s degree or master’s in computer science, software engineering, or a related field of study. Many employers also seek out database engineers who have at least five years’ previous work experience in database development. Database engineers who possess extra education, such as a master’s degree, can substitute education for work experience. Database engineers receive little to no training after being hired, as they have already acquired the necessary education and skills to perform their daily job tasks. However, most companies will provide a brief orientation period to help them become familiar with company systems and other employees. This orientation typically lasts less than one week.
Database Engineer Salary and Outlook
According to information compiled by the , software developers earned an annual median pay of $102,280 in 2016, or $49 an hour. Database engineers are a specialized branch of software developer and perform many of the same job tasks. In 2016, there were more than 1.2 million jobs for software developers of all types, a number that is rising much faster than the national job growth rate. The BLS estimates that jobs for software developers will grow by 24 percent from 2016 to 2026. Most companies provide full benefits packages to database engineers that include health, dental, vision, and life insurance coverage for employees and family members. Retirement benefits are also standard. Database engineers earn vacation days and paid sick days after being employed by the same company for a set period of time, usually one year.
Helpful Resources
Use these helpful resources for database engineers to learn tips and strategies for success, find career and networking opportunities, and discover ways to advance through promotion:
Database System Concepts – Learn the fundamentals of managing databases, data structure, and computer organization in this book, an educational textbook for senior undergraduate and first-year graduate database engineering students.
International Association of Computer Science and Information Technology – IACSIT provides professionals in all computer science fields, including database engineers, with news updates, educational resources, information about upcoming conferences, and resources for professional societies which provide career networking opportunities.
Database Reliability Engineering: Designing and Operating Resilient Database Systems – This book provides practical database engineering solutions for crafting and maintaining databases and related systems. The text covers key aspects of database engineering, including creating and managing programs for data storage and retrieval.
Association for Computing Machinery – Find educational tools, computing publications, upcoming conferences, and frequently-updated content for computing professionals of all types, including database engineers, at the ACM website.
Database Systems: Design, Implementation, & Management – This book is written in simple, straightforward language to help database engineers understand how to manage, design, and implement database systems. Along with text, this book contains comprehensive diagrams, illustrations, and tables for database engineers of all skill levels.