Database Consultant Resume Sample
Work Experience
- Knowledge of and experience with PL/SQL scripting
- Related (progressive, post-baccalaureate) experience
- Autonomy - Works under general direction within a clear framework of accountability. Substantial personal responsibility and autonomy. Plans own work, to meet given objectives and processes
- Influence - Influences team, and specialist peers internally. Influences customers at account level and suppliers. Some responsibility for work of others and allocation of resources. Participates in external activities related to specialization. Decisions influence success of projects and team objectives
- Complexity - Broad range of complex technical or professional work activities, in a variety of contexts
- Backup / HA technologies, such as RMAN / Active Data Guard etc
- Write, debug and tune SQL, PL/SQL, Perl & Shell scripts
- Act as a liaison serving as primary point of contact between application business segments and database administrators
- Documentation of operations and services
- Build and maintain load procedures
- Build and maintain extract procedures
- Document workflow in Product Tracker
- Work with DBA / SME to best architect new data tables
- Build ContentManager transactions for end users to view / manage content
- Build Oracle stored procedures, functions, views
- Build SQL queries
- Desire to understand data relationships and business uses
- Interest to learn new systems/tools
- Assisting in the development and implementation of various strategic initiatives around Meta Data Management, Master Data Management, Data Quality, Data Architecture Policies, Standards and Governance
- Partner with project teams and interact with customers to find solutions for projects and operational issues for existing and proposed data flows
- Along with other key personnel, ensure the overall data integrity and conformity of the information gathered. Manage data quality tasks through the ETL processes
- Work with DBA Group, Development Teams, and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.)
- Map Import/Export Files to source system data. Map source data to data warehouse models
- Develop and maintain ETL scripts and workflows, SQL queries, VB/C++ script components, schedules, etc. using SVN for version control
Education
Professional Skills
- Strong skills in PL/SQL, PERL/Unix Shell, Windows PowerShell, tuning and debugging
- Applying operational expertise, including troubleshooting skills, capacity planning, and on-going and automated maintenance
- Critical systems thinking skills, including the ability to comprehend complex business problems quickly
- 8+ of analytical skills and capable of influencing on technical issues
- Good IT skills (Microsoft Office, Excel, Word)
- Demonstrated experience with relational databases, database structures and design, systems design, data management, data warehouse
- Strong Oracle or Microsoft SQL Server database administration experience
How to write Database Consultant Resume
Database Consultant role is responsible for analytical, software, finance, integration, database, security, architecture, reporting, design, research.
To write great resume for database consultant job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Database Consultant Resume
The section contact information is important in your database consultant resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Database Consultant Resume
The section work experience is an essential part of your database consultant resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous database consultant responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular database consultant position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Database Consultant resume experience can include:
- Engage with global and StaffIt service teams to understand future system upgrades and effectively communicate recurring errors and concerns
- Implementing and administering database documentation, guidelines, policies and procedures
- Drive performance analysis and tuning, disk space management and capacity planning, as well patching and upgrading databases
- Regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports
- Document, including diagrams, the architecture and components of the Reporting data warehouse
- Modify existing ETL processes to improve performance and adapt to changing requirements
Education on a Database Consultant Resume
Make sure to make education a priority on your database consultant resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your database consultant experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Database Consultant Resume
When listing skills on your database consultant resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical database consultant skills:
- Strong Oracle or Microsoft SQL Server database administration experience
- 1+ Advanced MS Office skills (MS Excel)
- Understanding of or experience supporting J2EE application
- Marketing execution experience
- Professional writing, editing, intranet and social media (i.e., blogs, pod casting, etc.) experience
- Experience automating scripts, ex: parameterizing, data driven scripting
List of Typical Experience For a Database Consultant Resume
Experience For Senior IT Database Consultant Resume
- Prioritize, coordinates, and manage multiple tasks and projects in a fast-paced environment
- Provide expertise in the review and correction of data integrity and / or reporting issues
- Manage, overseas/internal profile transfers, liaising with StaffIt services, ITS and OPM team and ensure that the profile transfer is success
- Graduate in Business, IT, engineering or environmental sciences
- Develop processes to identify and analyze data quality issues and recommendations to resolve
- Use SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issues
- Perform daily review of production data processes to ensure successful completion
Experience For OS Database Consultant Resume
- Review, understand, and provide feedback on functional requirements from a database perspective
- Is an expert in the creation of SQL stored procedures
- Participate on projects (e.g.: Cloud migrations), providing solution design recommendations reflecting an enterprise, strategic view and fit of the solution with established reference enterprise architectures
- Directly interface with Business Units to understand their requirements and advise accordingly
- Provide consultancy to multiple DB platforms and technologies
Experience For SQL Database Consultant Resume
- Design and maintain database architecture, data structures, tables, dictionaries and naming conventions to ensure the accuracy and completeness of all data master files
- Ensure data accuracy in Resource Management databases is consistent with other internal Deloitte systems
- Control and provide access to Resource management database for new starters
- Understand the impact of new changes and collaborate with Finance, HR and StaffIt services team and ensure the new changes reflects in the system
- Work with support teams of upstream systems on all employee data and engagement issues
Experience For Ast Database Consultant Resume
- Work with ITS to manage infrastructure requirements and troubleshoot infrastructure issues
- Manage Resource Management technical mail box queries
- Annual maintenance of business hierarchies across all systems
- Assist Finance with the regular data upload into the Resource Management Database
- All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery
Experience For Database Consultant Senior Resume
- Responsible for evaluating patch releases from Oracle and patching requests from development, and communicating constraints, issues, and timelines for deployment
- Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production
- 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), preventative action follow-through, and participation in weekly operations reviews
- Database and PL/SQL optimization including performance tuning, query optimization and supportability
- Proactive database monitoring and issue resolution
- Actively participate and contribute to projects involving enterprise systems enhancements
Experience For Principal Database Consultant Resume
- Implementation and ongoing support of high availability architecture (RAC, DataGuard databases, Goldengate, etc)
- Participate in project design and Oracle database design decisions. Refine and troubleshoot the design
- Create and maintain appropriate documentation about the database and the data architecture
- Project Estimation process - including attending project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates
- Excellent communication, time / project management, organizational, and analytical skills required
- Develop and implement Database security policies and procedures, in line with corporate objectives
- Support short term operational and strategic Medicaid encounter processing objectives of high acceptance rates for encounter data valued in millions of dollars across the Optum and C&S behavioral business
- Be a technical lead for the Encounters Team
Experience For IT Database Consultant Resume
- Be active participant in maintenance of departmental data mart
- Be active participant in development and maintenance of departmental encounters management system
- Develop and implement front end solutions to business processes, including changes in procedures by providers, claims operations or submissions via encounter processing system
- Self-driven, proactive problem solver / solution oriented
- Monitors trends and presents results for financial and operation purposes
- Develop and implement solutions through research and analysis of data and business processes
Experience For Competitive Intelligence Database Consultant Resume
- Generate ad hoc reports from departmental data mart
- Billable Project work 70% of time
- Evangelize the Nutanix platform to Application owners, DBAs and management
- Plan, design, and build new service offerings around customers’ selected Database platform
- Create toolkits and best practice documents and whitepapers
- Up to 70% of travel
- Robust experience in the use, management, and administration of large scale database environments in relation to Tier 1 mission critical and business critical applications
Experience For Msme Policy Reform Stakeholder Database Consultant Resume
- Able to design, implement and administer advanced Database capabilities such as (but not limited to) Database Mirroring, Disaster Recovery, Monitoring, Backups, and Restores
- Migrate database cross platform (e.g. Oracle on Unix to Oracle on x86 Linux)
- Investigate and assess the level of interest of the entities to work with the SEED project in building their capacity and improving their capabilities regarding MSME focused policy reform efforts, be it from the private or public sector’s perspective
- A PowerPoint presentation of the findings, conclusions and recommendations of the report to the senior management of SEED and USAID
- Develop and maintain short-term and long-term (1-3 yrs) Service Roadmap
Experience For Database Consultant Engineer Resume
- Data ingestion into Hadoop clusters
- Takes initiative to solve complex problems; takes an outside in perspective to identify innovative solutions
- Basic Unix, Linux, and Windows OS knowledge
- CSR experts and implementers
- Government of Egypt stakeholders
- Public sector reform champions
List of Typical Skills For a Database Consultant Resume
Skills For Senior IT Database Consultant Resume
- Experience working in AIX and Linux Operating Systems
- Hands-on scripting / coding experience in native SQL
- Experience designing and building database solutions hosted in Amazon Web Service (AWS) Technologies
- Experience designing and building database solutions hosted in Microsoft Azure
- Experienced in optimizing databases running on x86 virtual machines for high performance and reliability
- Experience with enterprise datacenter infrastructure including servers, storage, networking
- Experience working with Cassandra and Kafka in large enterprise environments
- Strong knowledge of relational and multi-dimensional database architectures, as well data modeling tools (ERwin)
Skills For OS Database Consultant Resume
- Marketing and project management experience within a matrix organization
- Consumer marketing or contact management experience
- Digital marketing experience, with knowledge of Real-Time Offer Management, API
- Experience coding with UNICA
- Oracle DBA working experience
- User Acceptance Tesing Experience
- Healthcare industry experience, especially Medicaid, claims processing, or Behavioral Health
- Experience with software development and / or testing methodologies
- Quality Assurance testing experience in a Database, Batch / ETL components
Skills For SQL Database Consultant Resume
- Experience in consulting or as a DBA (likely in early career development)
- Experience integrating Oracle Standalone and RAC systems with Oracle E-Business Suite
- Experience scripting languages such as, Bash, Python, PowerShell
- Trylon database and Raiser’s Edge database experience
- Experience with Access and, ideally, SQL Server
- Experience in a highly regulated and structured work environment
- Power user experience with IBM Unica software suite
Skills For Ast Database Consultant Resume
- Experience with Business Intelligence Tools (Cognos / Business Objects)
- Health & Human Services experience
- Experience with project management and/or leadership
- Database administration experience or equivalent education
- Has 6 years+ experience in support of Microsoft SQL Server databases in a transactional environment
- Experience with Oracle database replication
Skills For Database Consultant Senior Resume
- Intermediate experience with relational databases, database structures and design, systems design, data management, data warehouse
- Experience with Business Intelligence Tools (ie. Cognos/Business Objects)
- Experience with PL/SQL Developer
- Experience with relational databases, database structures and design, systems design, data management, data warehouse
- SQL, Oracle and MySQL experience
Skills For Principal Database Consultant Resume
- Experience with analytics in data warehouse environment
- Experience with Microsoft SSIS and / or other ETL tools
- Experience with UnitedHealth Group systems: CSP or UBH Facets, Enterprise Data Warehouse (EDW), UHC SMART Data Warehouse and UHC Unified Data Warehouse (UDW)
- Experience with other DB technologies such as (SAP Hana/MongoDB/PostgreSQL/MySQL/Db2)
- Creating and maintaining a Main Vendor Product Strategy (including components that the service is dependent on)
- Designing, implementing and administering operational security on Hadoop clusters
Skills For IT Database Consultant Resume
- Evaluating technology and architectural components supporting analytic modernization
- Ongoing updating and management of the databases
- Creating Strategic alignment of own service area together with Service Owner, Tech office and other Service Architects
- Administrating MySQL database
- Working with a scheduler / tools
- Proficient in designing, implementing and administering large complex database environments in both physical and virtual server hosting patterns
- Provide data analysis/troubleshooting/creation support to QA, Developers, Support and others allowing them to complete their assignments
Skills For Competitive Intelligence Database Consultant Resume
- Develop, test, and debug new functionality, and maintain/enhance existing functionality in using SQL, stored procedures and API’s
- Full understanding of the processes of data quality, data cleansing, and data governance
- Drive change and help business functions maximizing the value they are getting out of the DB platforms in use
- Identify and escalate situations requiring urgent attention, inform RM leads of recurring issues
- Design and build bespoke Access databases to support ecological surveys (land access, ecology surveys, commercial management including invoicing)
- High level of comfort in presenting by means of white boarding sessions and PowerPoint presentations
- Capacity building consultants, trainers, mentors and coaches
Skills For Msme Policy Reform Stakeholder Database Consultant Resume
- Knowledge of NoSQL best practices & NoSQL data modeling and schema design
- Detailed understanding of database / application architecture
- Database relational modeling & design concepts
- Basic understanding of common database administration tools
- Collaborate with team members to meet project related goals and support on-going maintenance
Skills For Database Consultant Engineer Resume
- Understand and maintain appropriate data release documentation and approvals according to company policies and procedures
- Performs performance tuning of queries and stored procedures
- Full understanding of Extract Transform Load (ETL) concepts and technologies
- Support real-time capabilities of a complex Marketing organization
- Maintain Reporting database (Cognos)
- Assist in the bi-annual recurring data upload
- Responsible for supervising the work of others
- Initiate corrective action plans to resolve issues impacting report quality
- Provide Database consultancy services to existing Nutanix customer as well as potential customers
List of Typical Responsibilities For a Database Consultant Resume
Responsibilities For Senior IT Database Consultant Resume
- This is primarily an 8-5, M - F position. However, scheduled and/or unscheduled off hours works is required
- Intermediate proficiency in Oracle / SQL
- Desire to learn and support other platforms
- Goldengate, SQL Server 2008/2012/2014, MongoDB
- Xperience with relational databases, database structures and design, systems design, data management, data warehouse
Responsibilities For OS Database Consultant Resume
- Liaise with the different project teams to understand the processes and information required
- Attendance at team meetings and client meetings
- Data related certifications (CDMP, MS SQL MCM, MCITP, MCA)
- Private sector reform initiatives
- Academic sector reform initiatives
Responsibilities For SQL Database Consultant Resume
- Business Development Service Centers (BDSCs)
- Non-Bank Financial Institutions (NBFIs)
- Large domestic and international corporations
- Knowledge of design and implementation of Kafka streams with Cassandra database
- Monitor and tune query performance
- Self-starter, pro-active and motivated
- SMEs and entrepreneurs