Jobs related to database

1) database administrator

Computer systems design and related services firms, banks, insurance companies, universities and health care are examples of the many different types of industries that a database administrator will find work.

In addition to being responsible for backing up systems in case of power outages or other disasters, a DBA is also frequently involved in tasks related to training employees in database management and use, designing, implementing, and maintaining the database system and establishing policies and procedures related to the organization’s data management policy.

The Key Responsibilities of a Database Administrator

A database administrator’s (DBA) primary job is to ensure that data is available, protected from loss and corruption, and easily accessible as needed.

· Software installation and Maintenance

· Data Extraction, Transformation, and Loading

· Database Backup and Recovery

· Security

· Authentication

· Capacity Planning

· Performance Monitoring

· Database Tuning

· Troubleshooting

Database Administrator Qualifications/Skills:

· Strong command of SQL and SQL server tools

· Advanced knowledge of database security, backup and recovery, and performance monitoring standards

· Understanding of relational and dimensional data modeling

· PowerShell and Unix shell scripting skills

· Familiarity with SSAS, SSIS, SSRS

· Strong mathematical and statistical knowledge

· Excellent written and verbal communication skills

Education and Experience Requirements:

· Bachelor’s degree in computer science or a related field

· One to three years of experience in database administration, information technology, database architecture, or a related field

· MCSE/MCSA certifications preferred

· Experience with Linux and Windows Server environments

· Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)

Execute the DROP DATABASE, START DATABASE, and ROLLFORWARD DATABASE statements.
Drop or alter any object regardless of who owns it.
Create tables, views, and indexes to be owned by other users.
Grant database privileges, including the DBA privilege, to another user.
Only the user Informix can modify system catalog tables directly. If you are user Informix, IBM® strongly recommends that you not modify the contents or schema of any system catalog table, because such actions can affect the integrity of the database.

2) database designer

Responsible for producing and designing a detailed data model of a database, including all necessary logical and physical design elements.

The Key Responsibilities of a Database designer

• Determine purpose of database.
• Gather information that will be recorded in database.
• Divide information into tables.
• Turn information into columns.
• Specify primary keys.
• Set up table relationships.
• Refine and enhance design.
• Apply normalization rules to ensure tables are structured correctly.
• Adjust, as necessary.
• Follow W3C programming standards to address accessibility guidelines.
• Develop structural design of various systems, applications, and databases for custom database-driven website.
• Coordinate information systems with program objectives.
• Code, document, and test programs.
• Create data migration/conversion techniques for system conversions or upgrades.
• Assist organizational members and clients with database-driven websites, network, database, and application training and technical support.
• Assist staff with internal systems, applications, and databases, including developing procedures, forms, and other organizational tools.

Education and Experience Requirements:

· Bachelor’s degree in Computer Science, Information Technology, Engineering, or another engineering, science, or technical field plus 5 years’ database experience.

· 2+ years of experience with process engineering or manufacturing is highly desirable.

· Experience with semiconductor-related fab database architecture design is highly desirable.

· 2+ years of experience developing C#, ASP.Net and SQL database applications in a manufacturing and R&D environment, ideally dealing in the areas of quality assurance, inventory management and component tracking processes.

· Expertise with C#, Microsoft SQL, Python, Matlab, C++, Visual Basic, JMP, VBA, ASP.Net, and Microsoft Azure is highly desirable.

· Experience with data analytics software systems.

· Ability to manage multiple projects simultaneously and follow through on process improvement

After several years of experience or further education, such as a graduate certificate or master’s degree in database technologies, database developers can advance to a more authoritative position in a company, including database architect or chief technology officer (CTO) careers. While most database designer work in an office setting during regular business hours, an occasional deadline or system problem might extend their working hours to evenings and weekends. With experience, many database designers can work from home or take on a consulting position, determining their own hours

3) data engineer

Data engineers are mainly tasked with transforming data into a format that can be easily analyzed. They do this by developing, maintaining, and testing infrastructures for data generation. Data engineers work closely with data scientists and are largely in charge of architecting solutions for data scientists that enable them to do their jobs.

Data engineers generally have a bachelor’s degree in computer science, information technology, or applied math, as well as a few data engineering certifications like IBM Certified Data Engineer or Google’s Certified Professional. In addition, data engineers possess a plethora of technical skills and the ability to approach problems in a creative manner.

The Key Responsibilities of a Data engineer

Data engineers are tasked with managing and organizing data, while also keeping an eye out for trends or inconsistencies that will impact business goals. Some of the most common responsibilities for a data engineer include:

· Develop, construct, test and maintain architectures

· Align architecture with business requirements

· Data acquisition

· Develop data set processes

· Use programming language and tools

· Identify ways to improve data reliability, efficiency, and quality

· Conduct research for industry and business questions

· Use large data sets to address business issues

· Deploy sophisticated analytics programs, machine learning and statistical methods

· Prepare data for predictive and prescriptive modeling

· Find hidden patterns using data

· Use data to discover tasks that can be automated

· Deliver updates to stakeholders based on analytics

Data Engineer Qualifications / Skills:

• Knowledge of best practices and IT operations in an always-up, always-available service
• Experience with or knowledge of Agile Software Development methodologies
• Excellent problem solving and troubleshooting skills
• Process oriented with great documentation skills
• Excellent oral and written communication skills with a keen sense of customer service

Education and Experience Requirements:

• BS or MS degree in Computer Science or a related technical field
• 4+ years of Python or Java development experience
• 4+ years of SQL experience (No-SQL experience is a plus)
• 4+ years of experience with schema design and dimensional data modeling
• Ability in managing and communicating data warehouse plans to internal clients
• Experience designing, building, and maintaining data processing systems
• Experience working with either a Map Reduce or an MPP system on any size/scale

4) database programmers

Database programmers they design the database structure so that it will perform properly with the number of expected records. Design structures that work OK for a few thousand records can make a database unusable at a few million records. They also need to make sure the data will maintain its integrity over time and that the data is secure from unauthorized changes or theft. They must thoroughly understand normalization and when to deformalize and why. They must understand performance and how to ensure data integrity. They must understand security and how to prevent data from being stolen or maliciously changed.

The Key Responsibilities of a Database programmers

· write instructions that affect the way in which sets of records stored in a computer system are organized, managed, accessed, and updated.

· These workers use specific database computer languages to write and test new database software; others update or repair existing programs; many are also required to write instructions or teach employees how to use the software.

· Some work on large projects involving many programmers; such workers are most likely to use tools that help speed up the programming process, allowing them to concentrate on those parts that are unique to a particular programming task.

Database programmers Qualifications / Skills:

• Excellent analytical and organization skills
• An ability to understand front-end users requirements and a problem-solving attitude
• Excellent verbal and written communication skills

Education and Experience Requirements:

• Proven work experience as a Database developer
• In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
• Knowledge of software development and user interface web applications
• Hands-on experience with SQL
• Familiarity working with .Net Framework, JavaScript, HTML, and Oracle
• BSc degree in Computer Science or relevant field

5) database developer

Database Developer are generally responsible for the performance, integrity, and security of databases. They are often also involved in planning, developing, and troubleshooting of databases.

The Key Responsibilities of a Database developer

• Design database systems. Database Developers’ main responsibility is to analyze the needs of an organization and produce an effective database system according to their needs and specifications. This includes collecting data, analyzing the data, designing algorithms, drawing flowcharts, and implementing code for the logic developed through the algorithms and flowcharts.
• Test databases. A database developer must be able to run performance testing procedures to ensure the proper operations of a database and to ensure that it is error-free. If any errors are thrown when the code runs, they need to be corrected and the code needs to be re-tested. This involves troubleshooting any potential problems, creating, and submitting test reports and database improvement.
• Develop database documentation. As a database is developed, the database developer must write documentation about the system and put together an operational manual. The documentation must include information regarding changes or improvements to the database as they are implemented.
• Work with the front-end development team. Once the databases are ready, and the front-end development is complete, a database developer must work with the front-end development team to integrate the modules together. Once this is done, the integrated code must again be tested and any errors must be fixed.

Education and Experience Requirements:

• Proven work experience as a Database developer
• In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
• Knowledge of software development and user interface web applications
• Hands on experience with SQL
• Familiarity working with .Net Framework, JavaScript, HTML and Oracle
• Excellent analytical and organization skills
• An ability to understand front-end users’ requirements and a problem-solving attitude
• Excellent verbal and written communication skills
• BSc degree in Computer Science or relevant field