Job Summary:

• Performs database development tasks in all areas of software/application development lifecycle, including independent analysis and problem resolution.
• Collaborates with project managers, subject master experts, and software engineers to architect and model data structures, and implement complex data schemas in support of business applications.
• Develop best practices for database design and development activities including creation of queries, functions, and stored procedures to support application development.
• Develops, plans and establishes database performance baselines. 
• Monitors performance trends and optimizes SQL queries, views, functions, and stored procedures.
• Guides complex development tasks and projects to successful completion.
• Maintains and validates coding and software standards.
• Prepare database development and testing schedules.
• Delivering data for a variety of data integration projects
• Producing and testing code for ETL frameworks
• Performance tuning SQL queries and databases
• Streamlining and automating operations
• Ensuring data assets are well managed

Skills on Resume:

• Database Development (Hard Skills)
• Data Modeling (Hard Skills)
• SQL Optimization (Hard Skills)
• ETL Development (Hard Skills)
• Performance Tuning (Hard Skills)
• Coding Standards (Hard Skills)
• Data Integration (Hard Skills)
• Automation Skills (Hard Skills)

Job Summary:

• Undertake data cleansing, data manipulation and targeted selections as per campaign requirements
• Ability to work under pressure and to deadlines & tackle simultaneous tasks and projects effectively
• Run checks and tests to ensure both the accuracy and quality of the selections and outputs to brief
• Ensure processes are as efficient as possible through continuous reviews and up-skill
• Responsible for escalation of potential issues on designated client account tasks to senior team members as appropriate
• Accountable for all assigned operational outputs and deliverables in a timely and accurate manner in accordance with agreed SLA’s
• Work on simple standardised development project tasks allocated by team leaders
• Responsible for internal communication on all assigned tasks and projects and escalation of potential issues or delays
• Follow more2 coding standards of SQL and keeping the scripts tidy at all times
• Responsible for developing and adhering to process and procedure
• Recommending enhancements to existing systems, process and new products delivering findings to the team to ensure continuous improvement

Skills on Resume:

• Data Cleansing (Hard Skills)
• Quality Assurance (Hard Skills)
• Process Efficiency (Hard Skills)
• Issue Escalation (Hard Skills)
• Operational Accountability (Hard Skills)
• SQL Coding Standards (Hard Skills)
• Internal Communication (Hard Skills)
• Continuous Improvement (Hard Skills)

Job Summary:

• Architect, design and oversee the development of the database mapping and migration processes.
• Create T-SQL stored procedures, user-defined functions, and other objects that assist in the implementation of business rules/logic for Application UI and backend process using Microsoft SQL Server.
• Create and maintain SSIS packages, SSRS reporting and SOL Agent jobs.
• Design and develop relational database models/schemas.
• Design and make recommendations to improve current processes.
• Provide technical support and guidance in the investigation, analysis, and resolution of database problems on Production.
• Monitor database performance, troubleshoot issues, and resolve problems.
• Provide guidance for future efforts such as migration to the Azure cloud
• Interpret internal briefs and peer testing of solutions
• Design and write SSIS solutions to load client data
• Interact with many parts of the business on both a technical and non-technical level
• Produce and update technical documentation

Skills on Resume:

• Database Architecture (Hard Skills)
• T-SQL Development (Hard Skills)
• SSIS Package Management (Hard Skills)
• Relational Database Design (Hard Skills)
• Process Improvement (Hard Skills)
• Technical Support (Hard Skills)
• Performance Monitoring (Hard Skills)
• Documentation Skills (Hard Skills)

Job Summary:

• Manage and lead the architecture of enterprise data solutions that are scalable and maintainable
• Coordinate with various stakeholders to develop and achieve various long-term objectives for data architecture
• Monitor performance and manage parameters to provide fast responses to front end users
• Work with and provide data design and technical direction to various application and development teams.
• Database development for web application implementation and maintenance
• Database design and optimization for implementation of new application features
• Database administration for support of application development and testing
• Troubleshooting and analysis of issues regarding database operations, performance, and application functionality
• Assisting with impact analysis of changes made to database objects
• Install SQL Server and associated tools, database creation, monitoring and tuning of database instances
• Implement and validate security for SQL Server Databases
• Providing technical support to application development teams, operations teams, and tiered help desk

Skills on Resume:

• Data Architecture (Hard Skills)
• Stakeholder Coordination (Hard Skills)
• Performance Monitoring (Hard Skills)
• Database Development (Hard Skills)
• Database Optimization (Hard Skills)
• Troubleshooting Skills (Hard Skills)
• SQL Server Administration (Hard Skills)
• Technical Support (Hard Skills)

Job Summary:

• Drive independently a project from inception to deployment with a solid focus on performance and robustness
• Follow software development process, including writing unit tests, perform code reviews etc.
• Work effectively with cross-functional teams to develop features
• Identify and build automation frameworks/scripts
• Provide support for production deployments and maintenance
• Design, code, test, and deploy Oracle database code
• Implement assigned components as defined in system design
• Assist in setup and evaluation of overall architecture
• Collaborate to design and implement features
• Support and work in a continuous development environment
• Design and implement efficient data pipelines (ETLs) to integrate data from a variety of sources into a centralized enterprise-level data warehouse environment.
• Develop, maintain, and deliver technical documentation related to ETL development, planned processes, transformations, etc.
• Work with IT resources and other departments together in planning, requirements gathering, design, development, and validations of all projects.
• Monitor database events and continuously optimize system performance through troubleshooting and tuning.

Skills on Resume:

• Project Management (Hard Skills)
• Software Development (Hard Skills)
• Automation Frameworks (Hard Skills)
• Oracle Database Development (Hard Skills)
• Data Pipeline Design (Hard Skills)
• Technical Documentation (Hard Skills)
• Cross-Functional Collaboration (Hard Skills)
• Performance Optimization (Hard Skills)

Job Summary:

• Provide technical expertise and support in the use of DBMS
• Evaluate and recommend available DBMS products to support validated user requirements 
• Define file organization, indexing methods, and security procedures for specific user applications
• Create and maintain database objects such as tables, views, index, constraints, etc. for data platform and custom applications 
• Work with Production DBAs in developing, implementing, and maintaining database backup and recovery procedures for the process environments, and ensure that data integrity, security, and recoverability are built into the DBMS applications 
• Drive end-to-end availability, performance monitoring, and capacity planning for Microsoft SQL, using native and 3rd party tools
• Design and develop logical and physical database designs from application requirements
• Design and implement automation using scripts and database functions
• Design and implement replication and backups for mission critical/tier-1 application
• Design and implement automation using scripts, must be proficient in scripting 
• Develop data solutions based on user requirements within a restricted data environment
• Maintain and occasionally build database structure in SQL with appropriate referential integrity
• Monitor SQL Agent and SQL Server Integration Services jobs for failures and resolve failed jobs
• Assist in development of ETL processes in SSIS
• Create and optimize database queries, database objects (i.e. tables, views, indexes, stored procedures, etc.) and work with application developers to design/maintain database relationships and content

Skills on Resume:

• DBMS Expertise (Hard Skills)
• Database Design (Hard Skills)
• Backup and Recovery (Hard Skills)
• Performance Monitoring (Hard Skills)
• Automation Scripting (Hard Skills)
• Data Solutions Development (Hard Skills)
• SQL Query Optimization (Hard Skills)
• ETL Process Development (Hard Skills)

Job Summary:

• Evaluate and maintain enterprise database architecture.
• Provide technical support and guidance in the investigation, analysis, and resolution of database problems.
• Define and analyze data requirements for database designs.
• Evaluate, establish, and implement policies and procedures relating to database management, security, maintenance, sizing and capacity analysis, and utilization.
• Support a suite of enterprise database applications, specifically all recent versions of MS SQL Server.
• Responsible for rolling out new data related releases.
• Work in a collaborative way with junior team members to ensure all standards and best practices are met when designing new solutions.
• Represent the technology team in internal and external audits as it relates to data policies and procedures.
• Provide guidance for future efforts such as migration to the Azure cloud.
• Performs database design, regular database management duties including backups and audits to ensure that SQL databases remain accessible, secure, and stable.
• Tests databases for performance, fine-tune 

Skills on Resume:

• Database Architecture (Hard Skills)
• Technical Support (Hard Skills)
• Data Requirements Analysis (Hard Skills)
• Policy Implementation (Hard Skills)
• MS SQL Server Support (Hard Skills)
• Collaborative Development (Hard Skills)
• Database Migration (Hard Skills)
• Performance Testing (Hard Skills)

Job Summary:

• Work as part of a cross-functional professional services team to deliver high-quality projects
• Interface with KORE teams to define, plan and deliver projects on time and on budget
• Provide technical consulting to customers
• Take ownership of projects and tasks
• Interface with clients for requirements definition, scoping, weekly project status.
• Bring best practices and innovation to the team
• Works collaboratively with program management and administrative departments to understand processes and needs for reporting efforts.
• Assists with researching, testing, and deployment of reporting based projects.
• Creates reports based on the needs of the agency using Microsoft SQL Server Reporting Services and proprietary reporting applications.
• Maintains reporting databases as needed and participates in meetings to further development of proprietary application.
• Customizes and creates forms and workflows by working closely with management to develop plans, test technology, and implement new solutions.
• Engages in professional development to stay current with the demands of the position.
• Must be skilled at understanding inter-dependencies and relationships from complex technical data sets and be a creative problem-solver with strong analytical skills.
• Provides coaching and reviewing the work of lower level technical staff.

Skills on Resume:

• Project Management (Hard Skills)
• Technical Consulting (Hard Skills)
• Requirements Definition (Hard Skills)
• Reporting Development (Hard Skills)
• Database Maintenance (Hard Skills)
• Workflow Customization (Hard Skills)
• Creative Problem-Solving (Hard Skills)
• Staff Coaching (Hard Skills)

Job Summary:

• Engage in deep dive analysis related to the products and usage patterns with a view toward generating new insights and assessing impact of change.
• Present statistics findings to engineering team for performance and trends analysis, and senior management team for strategic planning.
• Work with various test measurements data users to gather reporting requirements and understand the intent of reports and provide necessary suggestions.
• Build business intelligence dashboard (accessed by multiple team users), and be responsible for end-to-end BI report development for Internal and External users
• Develops and maintains database objects and coding, SSIS packages and agent jobs to feature expansion of existing systems, new applications and integration requirements for internal and external systems.
• Perform data validation and make data corrections as necessary.
• Responsible for SQL development and troubleshooting SQL Code and design (stored procedures, functions, tables, views).
• Collaborate with system users and developers on technical direction regarding improvement of existing or new feature functionality, resolve issues or escalations as they arise and manage change requests.
• Participate in a continual cycle of internal process improvement to support the development of new or enhanced services or the use of new applications and technologies to further serve the organization’s and client’s needs.
• Digging into code and working alongside others to create solutions for unobvious problems.
• Building tables, indexes, and models with PL/SQL
• Coming up with clear/obvious structure within systems of tables
• Identifying gaps between systems

Skills on Resume:

• Data Analysis (Hard Skills)
• BI Dashboard Development (Hard Skills)
• SQL Development (Hard Skills)
• SSIS Package Management (Hard Skills)
• Data Validation (Hard Skills)
• Technical Collaboration (Hard Skills)
• Process Improvement (Hard Skills)
• PL/SQL Modeling (Hard Skills)

Job Summary:

• Developing a good understanding of the data, business products and applications.
• Resolving business problems by understanding them through analysis and partnerships.
• Capturing and evaluating technical requirements and proposing solutions that align with the technology blueprint and standard methodologies.
• Conducting impact assessments, crafting and building scalable, reliable and innovative solutions and ensuring ongoing stability
• Actively participating in knowledge exchange through code and design reviews, exploring emerging technologies and engaging in productive conversation.
• Working with stakeholders to gather requirements
• Taking ownership of projects from development to deployment
• Promoting change across the IT functions
• Improving technical skills through a variety of training methods
• Produce a database schema based on application-related function and data type
• Provide documentation and training to the Database Administrator. 
• Build a method for storing future database data
• Design, code, and implement relational databases

Skills on Resume:

• Data Analysis (Hard Skills)
• Technical Requirements Gathering (Hard Skills)
• Impact Assessment (Hard Skills)
• Stakeholder Collaboration (Hard Skills)
• Project Ownership (Hard Skills)
• Database Schema Design (Hard Skills)
• Documentation and Training (Hard Skills)
• Relational Database Implementation (Hard Skills)

Job Summary:

• Able to design, develop, version, documentation, test and deploy stored procedures, views, tables and other database objects along with least privileged access always in mind with a sharp eye for performance
• Optimise and change backend code that access databases
• Work on backup, indexing, redundancy and replication strategies including those already in place
• Assist with change management of databases
• Be a source of knowledge for backend developers
• Implement best practises in regard to database security and integrity
• Use database analytical tools to analyse performance and generate reports
• Ability to create fast and efficient database queries with joins and cross referencing with multiple tables
• Gather data requirements and formulate into database deliverables
• Deliver high quality database components to support new functionality
• Expected to participate in the implementation and improvement of database team procedures and standards
• Support and contribute to database build/release lifecycle processes
• Offer SQL review/tuning expertise to non-database development teams
• Stay on top of and implement advanced database features and capabilities where it makes sense

Skills on Resume:

• Database Development (Hard Skills)
• Performance Tuning (Hard Skills)
• Backup Strategies (Hard Skills)
• Change Management (Hard Skills)
• Security Best Practices (Hard Skills)
• Query Optimization (Hard Skills)
• Data Gathering (Hard Skills)
• SQL Tuning (Hard Skills)

Job Summary:

• Apply data modeling, database design and database development skills in a collaborative manner to help the team create, maintain, monitor, and/or improve business owned dashboards, ETL processes, reports, tools, and custom web applications.
• Design and construct new MS SQL Server and Oracle database objects that enable efficient storage and retrieval of data.
• Help identify and resolve inefficiencies in team and application MS SQL Server and Oracle databases, Tableau/PowerBI dashboard extracts and queries, and ETL database operations.
• Translate Business/User requirements into conceptual database designs.
• Develop database tables, stored procedures, indexes, functions, views, and triggers as necessary to achieve efficient input/output of data to Frito Lay North America business team User facing apps, tools, dashboards, and reports
• Ensure database operations are producing complete and accurate data stories and results for business decision making Users
• Work closely with web developers, dashboard developers, reporting analysts, and data engineers to understand and construct as necessary the data functionality (algorithms), structure, and speed requirements needed to produce positive User experiences
• Monitor database health, table data freshness, slow performing or high memory usage queries/stored procedures, storage constraints, memory constraints, dormant tables, missing or un-used indexes
• Connect and Collaborate with IT DBAs to identify opportunities to enhance database capabilities (database upgrades, configuration changes, new functionality, etc.) and reliability (e.g., back-ups, test environment, up-time, etc.)
• Assist in implementing data dashboards and reports to all levels of the organization as needed
• Duplicate and launch exiting databases/ERP systems for additional facilities
• Meet with team members to develop system requirements, then build those features into applications
• Develop schedules and determine milestones

Skills on Resume:

• Data Modeling (Hard Skills)
• Database Design (Hard Skills)
• SQL Development (Hard Skills)
• ETL Processes (Hard Skills)
• Query Optimization (Hard Skills)
• Dashboard Development (Hard Skills)
• Database Monitoring (Hard Skills)
• Collaboration Skills (Hard Skills)

Job Summary:

• Loads information received periodically from clients into database using existing mechanisms and procedures
• Creates and maintains mechanisms for importing the necessary data into the database
• Ensures all data imported is correct and provides all needed feedback about the completed work, according to company workflow
• Creates various reports required by business
• Prepares system interface (internal application)
• Creates documentation for developed mechanisms and database changes, documentation for issues appeared and their resolution, in order to be considered for further references
• Completes tasks delegated by the superior employee within the deadline
• Keeps good collaboration with the team
• Assist with database development efforts, including database design, coding, and documentation.
• Writing and modifying medium to complex stored procedures and Triggers
• Develop complex reports using SSRS
• Usage of databases available on the cloud 
• Analyses, troubleshoots, and debugs the stored procedures from performance tuning perspective.

Skills on Resume:

• Data Loading (Hard Skills)
• Database Import (Hard Skills)
• Report Creation (Hard Skills)
• Documentation Skills (Hard Skills)
• Stored Procedure Development (Hard Skills)
• SSRS Reporting (Hard Skills)
• Cloud Database Usage (Hard Skills)
• Performance Tuning (Hard Skills)

Job Summary:

• Create and maintain database tables, views, and procedures
• Research development tools and techniques that can be applied to environment
• Independently research and resolve from beginning to end any data and technical issues related to various applications
• Review data replication processes and make recommendations to improve data quality
• Use data analysis and scripting tools to identify and resolve data integrity issues and automate processes
• Work with team to research, plan, install, configure, troubleshoot, maintain and upgrade software applications
• Perform system administration duties such as data entry, support, maintenance, configuration, report writing, etc. for various applications
• Create technical documentation and evaluate existing documentation for completeness and accuracy
• Provide recommendations and technical assistance on new and existing applications
• Use technical skills to develop tools and applications to support business objectives
• Ensure that development projects meet business requirements and goals, fulfill end-user requirements and identify and resolve system issues

Skills on Resume:

• Database Maintenance (Hard Skills)
• Data Analysis (Hard Skills)
• Issue Resolution (Hard Skills)
• Data Replication (Hard Skills)
• System Administration (Hard Skills)
• Technical Documentation (Hard Skills)
• Application Development (Hard Skills)
• Project Management (Hard Skills)

Job Summary:

• Develops new systems and changes to existing systems to meet the needs of business partners and improve the user experience.
• Troubleshoots and debugs EDW and other data related ETL issues to identify solutions.
• Collaboratively refines and estimates work with the team.
• Contributes to code quality by writing and executing unit tests, drafting human-readable code, giving and receiving feedback in code reviews, etc.
• Brainstorms process improvements for team and enhancements for processes.
• Prepares documentation for purposes of learning and onboarding, as well as for releases of code to production.
• Make necessary modifications to systems based on manager feedback and improve overall usability of the system by providing regular system updates
• Document all programming tasks and procedures
• Perform routine software maintenance

Skills on Resume:

• System Development (Hard Skills)
• ETL Troubleshooting (Hard Skills)
• Code Quality (Hard Skills)
• Process Improvement (Hard Skills)
• Documentation Skills (Hard Skills)
• User Experience Enhancement (Hard Skills)
• Programming Maintenance (Hard Skills)
• Team Collaboration (Hard Skills)

Job Summary:

• Support the aggregation of data from multiple sources in an efficient data warehouse and designing enterprise-level solutions for multi-dimensional databases that are stable and reliable
• Develop implementation documentation which may include data sources, data diagrams, and other data movement process
• Requirements gathering, working with business leaders to understand reporting needs and design model to accommodate
• Apply software engineering best practices like version control, documentation, and continuous integration to the analytics code base
• Determine commonality between requests to implement reusable scripts and aggregate tables or views
• Support programming/software development using Extract, Transform, and Load (ETL) tools
• Responsible for the assessment and implementation of new technologies and providing long-term perspective on the relationship of database technology to the business
• Learning relevant business processes to understand the data flow, its significance, and its dependencies in a timely manner
• Research and suggest new database products, services, and protocols
• Performance tuning and optimization, using native monitoring and troubleshooting tools.
• Managing Production, Staging, QA and Development database environments

Skills on Resume:

• Data Aggregation (Hard Skills)
• Documentation Development (Hard Skills)
• Requirements Gathering (Hard Skills)
• Software Engineering (Hard Skills)
• ETL Support (Hard Skills)
• Technology Assessment (Hard Skills)
• Performance Tuning (Hard Skills)
• Environment Management (Hard Skills)

Job Summary:

• Proposing and delivering solutions for key market risk data platform applications
• Designing and implementing data models for accuracy, timeliness, quality and control
• Creating logical and physical data modelling
• Designing, implementing, and configuring large warehouse style databases – 30+ TB in size
• Performing performance optimizations – physical storage, data compression, partitioning, hashing, indexing, etc.
• Tuning databases and query performance optimizations
• Scripting in SQL and shell
• Integrating with upstream and downstream processes and systems
• Contributing to relevant technical standards
• Collaborate with a data team and IT to build a data warehouse.
• Monitor and validate weekly data replication of data tables through the FTP site.
• Collaborate with IT staff to maintain SQL server and monitor server capacity with weekly replication data.
• Write custom SQL queries.
• Collaborate with data team on report writing and data analytics.
• Assist in the delivery of data into the Tableau platform for analytics and visualization.

Skills on Resume:

• Data Platform Solutions (Hard Skills)
• Data Modeling (Hard Skills)
• Database Design (Hard Skills)
• Performance Optimization (Hard Skills)
• SQL Scripting (Hard Skills)
• System Integration (Hard Skills)
• Data Replication (Hard Skills)
• Tableau Integration (Hard Skills)

Job Summary:

• Monitors databases for proper performance
• Manages/Estimates storage for all applications
• Manages security and report incidents
• Administers server configuration, migration, and other implementations
• Monitors root cause analysis and resolutions
• Manages back-ups and recovery procedures
• Creates custom monitoring and maintenance plans
• Administers and tests new upgrades and databases
• Troubleshoots and resolves database problems
• Ensures audit trails are maintained and documented
• Collaborate with data team and organization
• Prioritize and understand data requests in the scheme of operational tasks.
• Maintaining current setup including optimization and exceeding industry best practice
• Design and implementation of new services within the database design

Skills on Resume:

• Database Monitoring (Hard Skills)
• Storage Management (Hard Skills)
• Security Administration (Hard Skills)
• Server Configuration (Hard Skills)
• Backup and Recovery (Hard Skills)
• Custom Maintenance Plans (Hard Skills)
• Troubleshooting Skills (Hard Skills)
• Service Design (Hard Skills)

Job Summary:

• Develop and optimize SPARQL queries
• Fully support the development team requests
• Ability to analyze problems and troubleshoot issues
• Contribute to semantic data design, including ontologies development
• Contribute to test automation and continuous integration
• Learn semantic technologies and other relevant skills for the job
• Abide by Tech & Data Policies and Procedures and SDLC/PLC requirements
• Creating tables, views, functions and stored procedures to support an ETL, Analytic and reporting applications.
• Tune and optimize queries for better performance.
• Maintain and develop applications written in PL/pgSQL to process customer data.
• Develop tools to monitor performance of data warehouses.
• Develop databases and updating databases
• Implement  data acquisition, processing and process analysis
• Analysing, implementing and maintaining a data integration system

Skills on Resume:

• SPARQL Development (Hard Skills)
• Problem Analysis (Hard Skills)
• Semantic Data Design (Hard Skills)
• Test Automation (Hard Skills)
• ETL Development (Hard Skills)
• Performance Tuning (Hard Skills)
• PL/pgSQL Maintenance (Hard Skills)
• Data Integration (Hard Skills)