Database Consultant Resume Samples
4.5
(66 votes) for
Database Consultant Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the database consultant job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.
Craft your perfect resume by picking job responsibilities written by professional recruiters
Pick from the thousands of curated job responsibilities used by the leading companies
Tailor your resume & cover letter with wording that best fits for each job you apply
Resume Builder
Create a Resume in Minutes with Professional Resume Templates
CHOOSE THE BEST TEMPLATE
- Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS
- Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES
- Instantly download in PDF format or share a custom link.
LN
L Nikolaus
Linnie
Nikolaus
939 Cortney Corners
Los Angeles
CA
+1 (555) 367 2458
939 Cortney Corners
Los Angeles
CA
Phone
p
+1 (555) 367 2458
Experience
Experience
Houston, TX
Database Consultant
Houston, TX
Hessel, O'Conner and Mitchell
Houston, TX
Database Consultant
- Work closely with Internal/External Stakeholders, Development Architects/Managers & developers, across locations and ensure timely delivery
- Providing expertise in investigating application issues / performance issues
- Developing and providing database monitoring / investigation tools specific to projects / with cross-project application, e.g. Oracle Application Express
- Collect and analyze database performance information; identify and implement solutions for performance problems
- Helping continuous improvement in the way the AD and infrastructure groups manage their database estate
- Control system resources usage and perform capacity planning, perform troubleshooting and diagnostics activities
- Report errors to development organizations
Dallas, TX
IT Database Consultant
Dallas, TX
Balistreri, Greenfelder and Gibson
Dallas, TX
IT Database Consultant
- Assists in development of systems and procedures affecting database management, design and maintenance
- Provide data administration support of the development and maintenance of production and non-production database environments for distributed applications
- Performance Tuning
- Support problem resolution; consult and advise in application design and tuning; plan, organize and execute product benchmarks for threshold and functionality
- Establish and maintain databases for user testing and production with direction
- Provide database administration for mission-critical custom and packaged database software
- Performance and Tuning
present
Boston, MA
Senior IT Database Consultant
Boston, MA
Lemke-McDermott
present
Boston, MA
Senior IT Database Consultant
present
- Review work performed by others and provides recommendations for improvement
- Provide status reports to senior management
- Conduct employee performance appraisals, provide feedback, coaching, team building and training/education to team members
- Provide guidance and expertise on tuning
- Help engineering teams understand the proper data management platform solution
- Manage and lead a team of Database Administrators
- Determine proper Surrogate Key/ID management strategy
Education
Education
Bachelor’s Degree in Business
Bachelor’s Degree in Business
Quinnipiac University
Bachelor’s Degree in Business
Skills
Skills
- Strong attention to detail
- Excellent communication skills
- Ability to multitask
- Product Knowledge
- Trylon database and Raiser’s Edge database experience
- Experience importing relevant data and storing historical records
- Object relational data management systems
- Experience performing test migrations
- Experience creating and importing files for Biographical data new records
- Query and database access tools
15 Database Consultant resume templates
Read our complete resume writing guides
1
Database Consultant Resume Examples & Samples
- Performing database health-checks
- Providing database / application tuning and optimisation expertise
- Providing expertise in investigating application issues / performance issues
- Developing and providing database monitoring / investigation tools specific to projects / with cross-project application, e.g. Oracle Application Express
- Proactive capacity and resiliency planning and execution
- Helping continuous improvement in the way the AD and infrastructure groups manage their database estate
- Reducing and managing the impact of change in a complex technical environment
- Proven knowledge and experience of the following technologies
2
Database Consultant Resume Examples & Samples
- Trylon database and Raiser’s Edge database experience
- Experience importing relevant data and storing historical records
- Experience performing test migrations
- Experience creating and importing files for Biographical data new records
3
Msme Policy Reform Stakeholder Database Consultant Resume Examples & Samples
- Work closely with all of SEED’s Components and the Enabling Environment Senior Advisor to identify the top public and private entities involved in the MSME policy reform process. These entities may include but are not limited to government, semi/quasi government, professional and trade associations, industrial councils, NGO’s, policy research centers, think tanks, universities, federations, chambers and any other relevant and active entity engaged in the MSME policy assessment and/or reform process
- Create a database comprising contact and operational information for each entity, including but not limited to contact person and organizational details, areas of focus, years in business, the names of those serving on the board of directors if possible, a cursory assessment of the organization’s strengths and weaknesses, and a numerical rating, between 1 and 10, of its relevance to the SEED Project
- Ensure the database of entities include their core services such as legal and/or regulatory analysis, poling and public opinion surveys, lobbying and advocacy services, and any sector or sub-sector focus or concentration (e.g. agriculture, industry, manufacturing, services, etc.). This may also include financial and non-financial service offerings or other priorities with respect to their target audiences, geographic focus, an emphasis on either national or governorate issues, or mission
- 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
- Always ask the identified entity who else in their circle of interest and perhaps influence SEED should speak to about building national capacity and efficiency in promoting public-private sector dialogue around policy reform relating to MSMEs
- Be available to the COP, Component Leads, and particularly the Enabling Environment Senior Advisor to contribute to meetings, presentations and other activities as requested
- Previous USAID experience
4
IT Database Consultant Resume Examples & Samples
- Candidate should have a degree related to Information Technology
- Database Administration experiences with Oracle databases on Unix platforms, preferably AIX as well on Wintel to included Design, Installation, Upgrades, Backup, Recovery, Performance, Tuning, Monitoring, Troubleshooting, Table maintenance, Re-orgs, Patching and Storage projections
- Have familiarity with Cerner
- Project Management experience is preferred
- Defines, installs, coordinates, implements, and tests database backup and recovery methodology for each data server. Work with team to monitor database performance and identify then correct performance bottlenecks
- Provides day-to-day support and guidance in handling the daily schedule of department production jobs. Technically stable data dictionary, data security and application database environments through appropriate monitoring/control. Effective management support through the timely response to management staff problems and needs
- Participates in and provides information into the designs of technical standards and policies regarding data, imports, exports and general access to data
- Adheres to the development and maintenance standards for data usage, manage the physical space and placement requirements of data, compile and assimilate information about the characteristics, accessibility, and interdependence of data
- Evaluates project assignments and present time and cost estimates for database modifications, development or installations
- Provides information on feasibility studies, request for information/proposal (RFI/RFP) assembly, capital or operating budgets or other planning sessions
5
IT Database Consultant Resume Examples & Samples
- Ability to defines, installs, coordinates, implements, and tests database backup and recovery methodology for each data server. Work with team to monitor database performance and identify then correct performance bottlenecks
- Experience providing day-to-day support and guidance in handling the daily schedule of department production jobs
- Ability to investigate new technologies/products and healthcare industry trends in respect to their implications on the responsibilities of department through the effective use of continuing education programs, associations, and publications
- Ability to participate in and provides information into the designs of technical standards and policies regarding data, imports, exports and general access to data
- Experience adheres to the development and maintenance standards for data usage, manage the physical space and placement requirements of data, compile and assimilate information about the characteristics, accessibility, and interdependence of data
- Experience evaluate project assignments and present time and cost estimates for database modifications, development or installations
- Ability to provide information on feasibility studies, request for information/proposal (RFI/RFP) assembly, capital or operating budgets or other planning sessions
6
Product Database Consultant Resume Examples & Samples
- The Consumer Data Management (CDM) Consultant is responsible for effective configuration, operation, and maintenance of system(s)
- Participate in technical research and development to enable continuing innovation of system(s)
- Ability to manage team members to meet project related goals and support on - going maintenance
- Must be self - motivated, goal oriented, and able to work with ambiguity and confidentiality
- Proficient with Microsoft Office & Microsoft Access
- Proficient in SQL / Oracle
7
Marketing Product Database Consultant Resume Examples & Samples
- Assist system users with technical issues and resolution
- These activities include: definition of needs, benefits, and technical strategy; research and development; technical analysis and design; and support in executing, testing and rolling-out the solution enhancements
- 3+ years of consumer marketing experience
- 3+ years of digital marketing experience, with knowledge of cookies, tagging, etc
- Strong, proven project management skills
- Excellent organizational, verbal, and written communication skills
- 3+ years of Healthcare experience
- Power user experience with IBM Unica software suite (such as, marketing resource management, Campaign and Interact)
- Knowledge of Search Engine Optimization (SEO) and Pay per Click (PPC) mechanics
8
Senior Database Consultant Resume Examples & Samples
- Installation, Configurations and maintenance of database software
- Database upgrades, patching, migrations
- Query optimization and tuning skills including cross database and cross server queries, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage
- Monitor SQL jobs in production and be responsible for load/hardware analysis mapping, fault tolerance and security
- Manage the indexing, database consistency checks, back-ups/recovery, security, replication, log shipping, etc
- Drive Operational efficiency topics
- Excellent written and communication skills, Strong customer focus, highly motivated &Flexible
- Participate and contribute towards organization’s goals and objectives, collaborating with multiple teams and solutions
- Own trainings and workshops
- Support the management
- Provide 24 hour coverage
- Performs weekend On Call tasks
- Around 5-10 years of overall database administration and support/operations experience, with a successful delivery track record
- Master in Oracle database administration
- Hands on experience with expert knowledge of Unix/Linux flavors
9
Marketing Product Database Consultant Resume Examples & Samples
- 3+ years of digital marketing experience, with knowledge of Real-Time Offer Management, API
- Must be proficient in SQL / Oracle
- Must be proficient in Microsoft Access
- 3+ years of Healthcare experience; understanding of the Federal Medicare and Retirement program
10
Senior IT Database Consultant Resume Examples & Samples
- Ensure performance, scalability, security, and availability of data platforms
- Prepare and give webinars and training sessions for engineering teams on best practices
- Resource to senior leadership
- Strong proficiency in RDBMS database management (Oracle, SQL Server, MySQL, etc.), 10+ years experience
- Exposure to NoSQL and / or Big Data
- Knowledge of data architecture standards and best practices
- Proficient in writing and optimizing SQL statements
- Knowledge of database features
- Experience on architecting and designing database solutions
- Ability to compare contrast relational vs. big data solutions and use cases for each type of platform
11
Marketing Product Database Consultant Resume Examples & Samples
- Experience with relational databases, database structures and design, systems design, data management, data warehouse
- Ability to prioritize, coordinates, and manage multiple tasks and projects in a fast - paced environment
- Intermediate proficiency in SQL
- Intermediate proficiency with Microsoft Office
- Intermediate proficiency in Microsoft Access
- 3+ years of Healthcare experience; understanding of the Federal Medicare and Retirement program preferred
- Experience with Business Intelligence Tools (ie. Cognos / Business Objects)
- Experience with Campaign Management tools (IBM Unica / Interact)
12
Database Consultant Engineer Resume Examples & Samples
- Work with Solution Architects, Application Managers, Information/Data Architects, Database Designer/Modelers, ETL Support Teams and Business Process Owners to implement environments for Golden Gate replication in support of Staples Initiatives, with emphasis on Data Warehouse Systems and Decision Support Systems
- Design, develop, administer and maintain relevant infrastructure
- Manage Golden Gate upgrade activities, enhancements requests and support of replication processes related to Project releases
- Assist in development and validation of Project requirements
- Provide input to the development of business cases in enterprise-wide solutions
- Develop and implement Golden Gate performance monitoring process and analyze monitoring data for performance optimization opportunities and capacity planning
- Communicate relevant requirements to the development team for the design and implementation of replication-related code
- Develop and implement standards for related to Golden Gate deployments
- Address performance issues and develop relevant processes concerning data integrity
- Provide incident management, problem management and SLA support
- Provide off hours support and be part of the on-call rotation as required
13
IT Database Consultant Resume Examples & Samples
- Anticipate customer needs and proactively develop solutions to meet them
- Solve complex problems and develop innovative solutions
- Experience with MS SQL Server 2008 or higher
14
Competitive Intelligence Database Consultant Resume Examples & Samples
- Leads large, complex projects to achieve key business objectives
- Influences senior leadership through effective visualizations and competitive intelligence tools
- 5 - 7 years relational databases, database structures and design, systems design, data management, data warehouse
- Ability to prioritize, coordinate, and manage multiple tasks and projects in a fast - paced environment
- Intermediate proficiency in SAS and SQL
- Intermediate proficiency in Microsoft Access and Microsoft Excel
- Self - motivated, goal oriented, and able to work independently
- Ability to comprehend complex business problems quickly and connect the dots
- Ability to work well with others including influencing without any direct authority
- Experience with troubleshooting technical issues related to code or tools
- B.A. and / or experience in a Database Marketing or Business Intelligence role
- Demonstrated ability to manage people and prioritize deliverables
- Experience with Business Intelligence Tools (i.e. Micro strategy, Tableau)
- 10 years of Marketing and project management experience within a matrix organization
15
IT Database Consultant Resume Examples & Samples
- Installation, administration and configuration of SQL 2016/2014 and other supported lower version of Microsoft SQL Servers
- Participate in 24x7 on - call support
- Define Backup / Recovery strategy
- Design and architect various high availability and disaster recovery solution as well long term archival process
- Experience on different type of database backup, replication, recovery, restoration, solutions
- Excellent knowledge in other RDBMS and cross platform technology concepts
- Knowledge on Azure or cloud based solutions on SQL platform, supporting key, business initiatives
- Experience on automation and PowerShell scripting to build infrastructure for automation
- Experiences on BI, Data ware housing architecture and implementations
- Support problem resolution; consult and advise in application design and tuning; plan, organize and execute product benchmarks for threshold and functionality
- Participate in product evaluations, design review session, data requirement meetings and consulting with application development products
- Review ongoing and proposed projects to identify opportunities for reuse and process improvement
- Bachelor’s Degree in Computer Science or related computer discipline
- 5 years of strong Microsoft SQL Server database administration experience
- 5 years of production support experience
- 5 years experience with relational databases, database structures and design, systems design, data management, data warehouse
- Oracle and MySQL experience
- Power shell experience
- Professional experience in the health care industry
16
Marketing Product Database Consultant Resume Examples & Samples
- 3+ years of consumer marketing experience required
- Experience with relational databases, database structures and design, systems design, data management, data warehouse, MS Access and SQL required
- Ability to work well independently as well as a team player
- Creative thinker, problem solver, technical leader
- Demonstrated project management experience
- Demonstrated in-depth knowledge of Database (SQL, Teradata, Oracle), data warehouse architecture, design and development in team-oriented environments
17
Marketing Product Database Consultant Resume Examples & Samples
- Ability to prioritize, coordinate and manage multiple tasks and projects in a fast-paced environment
- Excellent organizational, verbal, and written communication skills required
- Must be proficient to advance in SQL / Oracle
- Demonstrated in-depth knowledge of Database (Teradata, Oracle), data warehouse architecture, design and development in team-oriented environments
18
Senior IT Database Consultant Resume Examples & Samples
- Experience with Agile tools Liquibase and / or Flyway
- 10+ years of experience in the Information Technology profession
- 10+ years working with RDBMS
- Experience with NoSQL and / or big data solutions, 1 - 2 years
- 10+ years of analytical skills and capable of influencing on technical issues
- Broad knowledge of relational database technologies
- Experience with Agile tools Liquibase and/or Flyway
- 5+ years Software Development experience
19
Marketing Product Database Consultant Resume Examples & Samples
- Support real - time capabilities of a complex Marketing organization
- Work with Web Services and Offer Management application to move data and improve the consumer experience
- Participates in the development of business strategy
- Participates in large, complex projects to achieve key business objectives
- Power user experience with IBM Unica software suite such as Campaign and Interact (or comparable application)
- Working knowledge of relational databases, database structures and design, systems design, data management, data warehouse
- Working knowledge of web services
- Ability to collaborate with team members to meet project related goals and support on - going maintenance
- Excellent interpersonal skills required
- Ability to understand complex business problems quickly
- 3+ years of digital marketing experience
- Proficiency with Microsoft Office
20
Senior MS SQL Database Consultant Resume Examples & Samples
- Designing and implementation MS SQL High availability solution Microsoft SQL server clustering, Replication, Mirroring, AlwaysOn Availability Groups
- Designing, implementing and managing Microsoft SQL Server systems,
- Migrating from old infrastructures to new ones (SQL Server 2005/2008/2012)
- Provide guidance and counselling
21
Senior IT Database Consultant Resume Examples & Samples
- Actively participate in all phases of project development life cycle including database policies, procedures, standards and supporting documentation, database design, process flow analysis, development, benchmark analysis, performance / tuning, capacity planning, and production implementation
- Conduct employee performance appraisals, provide feedback, coaching, team building and training/education to team members
- Conduct interviews for recruitment of full - time and consulting positions as required
- Assisting with communication interfaces / integration to associated systems
- Strong proficiency in Oracle (7+ years)
- Knowledge of data architecture (3 years), standards and best practices
- Be able to benchmark and present findings
- Self-motivated and highly accountable
- Basic Unix experience (navigation, script maintenance, system monitoring)
- Post - graduate degree in applicable area of expertise or equivalent experience
- Experience w / SQL Server or MySQL
- Agile Team experience
- Usage of Source Control tools (SVN, etc)
- Medical Industry and / or Coding experience
- Proficient understanding and use of code versioning tools (such as Git / SVN)
22
Senior IT Database Consultant Resume Examples & Samples
- Be a lead on a team of Database Administrators
- Production support responsibilities include maximizing system availability, ensuring swift and complete database recovery, optimizing database and availability through ongoing maintenance, and ensure conformance to audit and operating standards on both local and remote databases
- In depth MS SQL Server experience is a must
- Experience scaling SQL Server to large implementations
- General knowledge of Oracle a must
- Experience reviewing code and schema changes done by others
- Experience working with End Users / Clients to walk through troubleshooting
- Post-graduate degree in applicable area of expertise or equivalent experience
- 6+ years of experience in the Information Technology profession
- 6+ years working with RDBMS
- 3+ years of Oracle knowledge/experience
- Healthcare experience desirable
- 6+ years of analytical skills and capable of influencing on technical issues
23
Senior Marketing Product Database Consultant Resume Examples & Samples
- Bachelor degree in business, technology, related field or equivalent combination of education and relevant experience
- 5+ years of consumer marketing experience
- Experience with relational databases, database structures and design, systems design, data management, data warehouse, MS Access and SQL
- Must be proficient with Microsoft Office
24
OS Database Consultant Resume Examples & Samples
- Perform logical database design for OS2200 DMS hierarchical databases
- Perform physical database design for OS2200 DMS hierarchical databases
- Code and interpret schemas for OS2200 DMS hierarchical databases
- Code and interpret subschemas for OS2200 DMS hierarchical databases
- Perform database reorganizations for OS2200 DMS hierarchical databases
- Perform logical database design for OS2200 RDMS relational databases
- Perform physical database design for OS2200 RDMS relational databases
- Code and interpret schemas for OS2200 RDMS relational databases
- Code and interpret subschemas for OS2200 RDMS relational databases
- Create COBOL programs to perform database unloads and reloads, as needed, for OS2200 DMS and RDMS database maintenance functions
- Create hierarchical (DMS) database maintenance and reorganization routines, as needed, using I-QU PLUS-1 software from KMSYS Worldwide Inc.(http://www.kmsys.com)
- Create hierarchical (DMS) database maintenance routines, as needed, using OS2200 DMU and DRU utilities
- Coordinate and maintain the data dictionary using the UREP products
- Proactively monitor the sizes of OS2200 DMS and RDMS databases and proactively develop and execute plans to increase sizes of databases and make recommendations on purge and archive processes to deal with the removal of old records
- Proactively monitor OS2200 DMS DARP and SARP page usage for handling the storage of additional records onto overflow pages
- This is critical so that there is always a sufficient amount of overflow pages to handle the requirements of the customer’s mission-critical applications
- Perform capacity planning for OS2200 DMS and RDMS databases to plan for disk storage capacity to meet the needs of current and upcoming applications
- This is also critical to help ensure that sufficient lead time is availalble for funding, purchasing, and preparing additional disk storage
- Assist in diagnosing and addressing application issues in COBOL programs that use OS2200 DMS and RDMS databases
- Based on the nature of the application issues and the impacts to the database design and integrity, this consultant will be called upon to develop automated processes to identify and correct the impacted fields in database records and relationships between records
- The COBOL programs may perform transaction processing or batch processing
- Familiarity with both transaction and batch processing is critical
- The customer also has a large number of Windows-based custom-built .NET multi-tier applications that integrate with the OS2200 COBOL applications and DMS and RDMS databases
- Familiarity with distributed transaction processing based on the x/Open model and standard is critical
- Be proficient in the use of the DBE (Database Editor) utility for performing analysis and maintenance of OS2200 DMS databases
- This consultant will be required to work non-standard hours, on occasion, to complete some of the migration work to avoid disrupting users or systems during the normal business day
25
Product Database Consultant Resume Examples & Samples
- The Consumer Data Management (CDM) Consultant is responsible for design and programming of intelligent member selection campaigns for marketing and clinical intervention
- Work with business owners to understand intent of campaigns and ensure coded flowcharts deliver to their specifications
- 3+ years of database management / marketing execution experience
- 3+ years of coding experience: SQL / UNICA
- 1+ years of experience with project management or leadership
- Advanced level of proficiency with relational databases, database structures and design, systems design, data management, data warehouse, Microsoft Office, MS Access, and SQL
- Ability to manage team members to meet project related goals and support on-going maintenance
- Ability to prioritize, coordinate, and manage multiple tasks and projects in a fast-paced environment
26
Database Consultant Senior Resume Examples & Samples
- Monitor & Manage Databases
- Manage All Version & Edition of Oracle Databases ( 11gR2 till latest version)
- Manage Database in different environments like Unix & Linux
- Perform Database Health Checks
- Install, patch and maintain all Oracle software
- Design and implement a backup & recovery system
- Perform Database Upgrade
- Configure Data guard
- Configure RAC & Maintain the environment
- Perform Platform Migration Project
- RMAN Cloning
- RMAN/Logical backup & restore activities
- Performance Monitoring & Tuning
- Perform basic tasks in Goldengate /Exadata /Grid
- Configure OS Scripts (bash/Shell)/perl/php) towards Database Support
- Troubleshoot data warehouse and OLTP problems
- PLSQL programming knowledge
- Analytical skill to grasp the proprietary applications
- OEM/Grid control
- Database Audit and Security
- Knowledge/Working of Materialized views
- Knowledge/Working Partitioning
- Innovate ideas and for automating manual tasks
- Remedy knowledge
27
Principal Database Consultant Resume Examples & Samples
- Operate independently to provide quality work products to an engagement
- Apply Oracle methodology, company procedures, and leading practices
- Work independently as well as part of a team
- Demonstrate expertise to deliver functional and technical solutions on moderately complex customer engagements
- Act as the team lead on projects, providing coaching, guidance and feedback to develop skills of team members
- Effectively consult with management of customer organizations
- Travel as needed
- More than 7-9 years' experience as a consultant or equivalent position
- Hold BA/BC Degree in Computer Science or equivalent
- Architecture of middleware systems based on Oracle software and related technologies
- Implementation of (install, configure and verify) middleware platforms based on Oracle software and related technologies
- Swedish speaking is desired. English speaking is a must
- Oracle Databases (RAC, Data Guard etc.)
- Operating systems (Solaris, Linux etc.)
- Oracle Cloud Offerings (Database Cloud Service, Java Cloud Service etc.)
- Engineered Systems (ExaData, ExaLogic etc.)
- Methodology (OUM, RUP, SCRUM etc.)
- Oracle WebLogic
28
Senior IT Database Consultant Resume Examples & Samples
- Expertise in Requirement analysis, Database design and Strong Database Objects development skills including Tables, Views, Triggers, Stored procedures, Cursors and T-SQL batches
- Possess expertise in writing Dynamic SQL Scripts, PowerShell and automating various Audit procedures as per the Organizations requirements
- Design storage strategies around backup and recovery for complex database environment, physical structures, and specialized database applications/systems
- Demonstrate the knowledge and ability to perform in all of the basic database management skills of database administration, Web connectivity, physical structure, overall architecture and database analysis
- Participating in data architecture design and review processes
- Conduct interviews for recruitment of full-time and consulting positions as required
- 10+ years of MS SQL knowledge/experience
- 10+ years of People Management experience
29
SQL Database Consultant Resume Examples & Samples
- The methodical investigation, analysis, review and documentation of all or part of a business in terms of business functions and processes, the information used and the data on which the information is based
- The definition of requirements for improving any aspect of the processes and systems and quantification of potential business benefits
- The creation of viable specifications and acceptance criteria in preparation for the construction of information and communication systems
- Investigates operational requirements and problems, contributing to improvements in automated and non-automated components of new or changed processes. Assists in defining acceptance tests for automated systems
- Key Tasks
- Works with colleagues and clients/users to investigate and model business functions, processes, information flows and data structures, using methodical and consistent techniques
- Works with colleagues and clients/users to investigate operational requirements and problems, contributing to improvements in automated and non-automated components of new or changed processes/procedures, organization and equipment
- Works with colleagues and clients/users in specifying information flows, processes/procedures and data objects that will meet the business requirements
- Takes part in client/user meetings and assists in presenting issues and solutions both orally and in writing
- Assists colleagues and clients/users in defining acceptance tests for automated systems
- Assists in defining, planning and justifying (in business terms) projects to develop/implement automated and non-automated components of new or changed processes
- PM Web experience
- Design, Construction, Architecture, Real Estate Development or Facilities Management exposure
- Experience in document management, system administration, data governance
- LSS Yellow Belt required or obtained in the first year
- Team Leadership and Management
- Comfortable with technology; word processing, spreadsheet, and database software preferred
- Strong administration skills
- Strong knowledge of an Electronic Document Management Systems, Document Control Tools, or Collaborative Project Management software such as Constructware, Prolog, Primavera, Newforma, Aconex, Asite or similar, AutoCAD, AutoCAD Revit
- Good written and oral communication, attention to detail, organizational and interpersonal skills, as well as a demonstrable ability to interact effectively with project professionals and management
- Bachelor's Degree in Computer Science, Information Systems, Business Administration, or other related field, or equivalent work experience
- Business area expertise and industry relevant certifications (APICS desired)
- Knowledge and understanding of business process framework (APQC desired)
- Exposure to business process modeling and simulation tools (desired)
- Exposure to enterprise data modeling exposure
- Business change/transformation techniques and processes
30
Database Consultant Resume Examples & Samples
- Incident Solving
- Additional Tasks: Must be able to work in a fast paced, high demand environment
- Develop and implement database backup and recovery solutions
- Develop and implement database security features (e.g. roles, privileges, authentication, encryption)
- Experience in database programming concepts including structured query language, stored procedures and triggers
- Review and implement database changes
- Provide timely response to system alerts and participate in the on-call schedule (if applicable)
- Work closely with Internal/External Stakeholders, Development Architects/Managers & developers, across locations and ensure timely delivery
- Additional Tasks
- Around 4-10 years of overall database administration and support/operations experience, with a successful delivery track record
- Sound knowledge in MSSQL and/or Sybase
- Knowledge & Experience on SAP HANA Administration/ Operations is an added advantage
- Knowledge & Experience on SAP MaxDB Administration/ Operations is an added advantage
- Good understanding of operational framework like ITIL/ITSM
- Bachelor or Master Degree in Technology
31
Senior Database Consultant Resume Examples & Samples
- Identify Source Data and develop relational database to model compensation costs and plan designs
- Build secure pathways and processes to integrate various types of source data into a secure database in support of compensation, quota setting and performance measures for comp and sales administration
- Creates visual presentations (tables, charts, graphs, etc.) of financial information; prepares and presents management and executive level reports for leaders across the organization
- Work across functions to drive efficient processes and systems, and leverage best practices
- Collaborates with global business areas to understand financial anomalies, identify trends, forecast potential impacts, and drive business decisions
- Provide insightful financial business reporting and analysis to help drive strategic decisions
- Maintain process and analysis of forecast and commission reports in various formats from global regions
- Ability to import data into excel, access and create formulaic responses and calculation to produce specified results using a variety of business rule which impact the treatment of data
- Partner with department heads to gather metrics and data for Key Performance Indicator (KPI) reporting and perform analyses
- Prepares daily, weekly and monthly reports and presentations
- Serves on special projects and completes other duties and ad-hoc analysis, as requested
- 8+ years business and/or technical/academic training on Data Management tools, financial analysis, reporting, including report development
- 5+ years experience with High-Level Mining and Reporting Tools. I.e. Crystal, BI, Cognos, Tableau, IDEA
- Knowledge of Data Integration tools and ETL software such as Informatica
- Experience in Database Administration
- Strong analytical background and demonstrated capability in developing and writing reports and queries in multiple software applications
- Ability to access relational data using SQL
- The ability to create and write business process documents
- Proficiency in Microsoft Excel formulas, pivot tables, lookup tables, and other data mining tools
- Excellent communication skills required to present findings and translate data into an understandable documents or presentations
- Highly motivated individual driven to keep pace in a fast moving and dynamic environment
- Ability to take risks and comfortable promoting valid ideas to Management
- Self-directed, willing to take initiative before being asked
- Ability to adapt to rapid change in a relatively unstructured environment
32
IT Database Consultant Resume Examples & Samples
- May consult with Systems Analysts and designers on procedures related to new or existing databases
- Establish and maintain databases for user testing and production with direction
- Performance and Tuning
- Define the complete technical infrastructure environment
- Review project deliverables for completeness, quality, and compliance with established project standards
- Identify, clarify, and resolve project activity issues and risks, escalating them as needed
33
It-database Consultant Resume Examples & Samples
- Install, upgrade and patch Oracle databases
- Automate database administration tasks using PL/SQL and shell scripts
- Secure privacy of data by enforcing data access policies
- Use Enterprise Manager and other tools for availability and performance monitoring
- 24x7 on-call rotation (approximately 1 week/month)
- Some after-hours and weekend work required to support database maintenance and application releases
- Managing multi-terabyte databases
- Optimizing ETL
- Interfacing with Hadoop
- Teradata administration
34
Database Consultant Resume Examples & Samples
- Identify and translate business requirements into functional and system requirements, information requirements, reporting requirements, interface requirements, data formats, operational characteristics, information flows, and security and accreditation considerations
- Develop use cases to capture the various ways that the system will be used and develop a requirements traceability matrix (RTM) specification document, including use cases where applicable and review/assist with development of technical requirements
- Document the relationships between requirements and other development lifecycle artifacts to ensure thorough coverage and functionality of all Government requirements via a published traceability matrix
- Produce a technical design to specify the technical architecture, technical functionality, DODAFs and other technical documentation required by the DoD; user interfaces and interfaces as required by the project/product
- Conduct system analysis support to ensure requirements compliance, identify problems of the existing application, correctly attribute them to automated processes and/or submission data and develop solutions
- Document the software release scope correlating the business requirements to the functional and technical requirements
- Create user interfaces that minimize training requirements, prevent help desk calls, protect the quality of the data and display error messages that guide the user to take the appropriate corrective action
- Implement software assurance into the SDLC to encompass the development and implementation of methods and processes for ensuring that software functions as intended while mitigating the risks of vulnerabilities, malicious code or defects
- Provide end to end software test plan to ensure test coverage of functional and technical requirements
- Provide application verification test plan, when migrating from legacy application to new technology solution.Qualifications: 10+ experience with Complex SQL queries, and generating reports using PL/SQL against Oracle Database
- Strong background with OLTP databases and OLAP (Data Warehouse and Data Marts) databases
- Ability to develop and test Oracle PL/SQL procedures and triggers; perform SQL tuning and re-write code as necessary; Develop and maintain functional and technical documentation
- Exceptional ETL Design/Development knowledge
- Strong experience in analyzing complex data, and entity relationships in Oracle tables to develop processes, and oracle components to identify, document and fix data discrepancies
- Strong scripting skills to perform data/file management (e.g. PERL, Python, Shell, etc.)
- Good understanding of Database Design and Data Modeling concepts
- Extensive experience in Data Migrations, Data Quality and Data Maintenance
- Knowledge of BI/Data Warehouse concepts, including star schema, aggregation processes
- Good knowledge of Cursors, collections and Advanced PL/SQL concepts
- Understand and interpret customer requirement and develop solutions to meet requirements
- Able to function independently with minimal oversight and direction
- Must be an effective team player
35
Ast Database Consultant Resume Examples & Samples
- A minimum of four (4) years of experience installing system software or database design experience
- Knowledge of Windows operating system fundamentals
- Knowledge of SQL server database backup and recovery procedures
- Knowledge and experience with high availability database solution design, implementation, and management
- Knowledge of database monitoring solutions
- Knowledge of database server security principals and best practices
- Ability to install and configure SQL server in complex environments
- Ability and experience tuning SQL server for optimal performance
- Ability to maintain and automate administrative tasks such as checking database statistics, backups, and index rebuilds
- Experience working in multi-tenant environments
- Ability to analyze and manipulate data including the ability to gather, manipulate, and report summary information (pivot tables)
- Ability to work under pressure and with multiple deadlines
- Attention to detail and consistency of work output
- Ability to develop and implement project plans
- Ability to communicate clearly and effectively in writing
- Ability to conduct efficient primary and secondary technical research online
- Ability to write administrative scripts
- Ability to troubleshoot software issues
- Knowledge of current software / hardware products and technologies
- Knowledge of virtualization, database, collaboration and messaging technologies
- Fundamental knowledge of basic networking technologies
- Fundamental knowledge of storage and data protection concepts
- Knowledge of the interactions between databases, servers, operating systems, networks, and storage with the ability to understand how changes in one area affects the others
- Knowledge of security principals and best practices
- Familiarity with Microsoft Visio and Excel