Job address
US
Company size
11-50 employees
Job sector
Information Technology
occupation category
Database Administrators
Job type
Contract
Work environment
In person
Company Overview
Releases upcoming
If you've received this job template as a recommendation, we're actively adding employers in your area with open positions like this. Stay tuned for updates!
Customize this section from your company profile.
Learner & Earner
Job details
Each Open Job posting will contain unique job details.
Employer
Bookmark this job template for quick access in your templates folder whenever you're setting up a new job posting.
Take note
These are Verified skills that candidates near you are sharing with our recommender.
Job details
Required skills
- Modifies code to address compatibility or other problems
- Resolves defects and rework code as needed to meet specifications
- Designs and makes changes where necessary to address end-user feedback
- Prioritizes work appropriately to meet deadlines, maintain focus, and solve complex tasks, seeking help as needed to address problems as they arise
- Considers the relative costs and benefits of potential actions to choose the most appropriate one
- Monitors organizational policies and procedures ensuring adherence to federal, state and international legislative requirements in order to implement and manage change
- Plans effective strategies for extraction, conversion and loading pipeline
- Uses the conceptual, logical, and physical models as the basis of the design
- Ensures seamless migration and conversion with minimal disruption
- Reads and comprehends query language SQL and/or NOSQL relational and document storage databases
- Plans, coordinates, and implements security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Validates architecture using models
- Supports high-level business rules in database code
- Identifies the business objectives and goals for the project with stakeholders
- Compiles, codes, categorizes, calculates, tabulates, audits, or verifies information or data
- Participates in development of user training plan to provide subject matter expertise
- Plans and implements application and data provisioning to appropriate users, exercising high levels of customer service and clear forms of communication, as needed
- Determines, implements, and monitors encryption
- Installs, configures, and tests network security
- Applies knowledge and experience in major relational database languages and applications, such as Microsoft SQL Server, Oracle and IBM, DB2.
- Creates complete design and interface specifications
- Assists with selection of design tools
- Uses Data Definition Language and Data Manipulation Language as needed to establish and configure database and servers
- Checks performance of prototype against specifications
- Conducts code review in accordance with company policy
- Defines release procedures and feedback processes as agreed upon by decision makers
- Identifies access and concurrency requirements
- Embeds debugging hooks into system
- Plans and implement application and data provisioning
- Prepares and conducts design review to ensure design addresses inputs and desired outcomes
- Develops physical database characteristics
- Develops and validates database implementation plan
- Specifies users and user access levels for each segment of database
- Documents and disseminates interruption and disaster recovery procedures
- Puts the application into production
- Identifies and confirms software, hardware, or environmental prerequisites for database conversion and migration
- Integrates measures to ensure privacy, confidentiality and data protection in adherence with state, federal and international rules and legislation and employers’ best practices
- Supports maintenance of database management systems and server software
- Implements backup and recovery methodologies to enable restoration capability in the event of an interruption or disaster
- Creates databases to store electronic data
- Writes and codes logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions
- Translates the application design into a completed, efficient application
- Creates normalized data model to ensure data is organized in the database
- Implements a systematic testing program to find hardware compatibility problems
- Evaluates, corrects and documents defects to ensure the system functions according to specification
- Performs user acceptance test
- Performs regression tests to thoroughly exercise the software according to plan and schedule
- Integrates subsystems iteratively until integration is complete
- Applies basic security measures to configure databases and servers including sanitization and counter-injection.
- Develops code using modern programming languages that connect DBS and API
- Chooses an architecture that will meet design specifications
- Applies knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
- Applies knowledge of the following software: Amazon DynamoDB; Elasticsearch; MongoDB; Oracle PL/SQL; Apache Hive; Blackboard software; MySQL; Oracle JDBC; Apache Ant; Apache Kafka; Common business oriented language COBOL; Go; Advanced business application programming ABAP; Apache Groovy; jQuery; Scala; Backbone.js; Google AngularJS; Microsoft ASP.NET Core MVC; Spring Framework
- Designs data distribution and disaster recovery solutions to capture information needed for storage and future troubleshooting
- Deploys database into production
- Trains employees in how to use the database management system
- Presents complete final set of requirements to stakeholders to attain approval
- Gathers data to identify customer requirements
- Creates database informed by development standards and requirements
- Implements framework for logging and error handling
- Prepares and transports data between servers and storage devices
- Installs and configures database management systems and server software for database usage
- Trains technical support staff to utilize the system and database
- Transitions to new system according to plan and specifications
- Creates cost-effective prototypes
- Develops code using efficient software design processes
- Ensures appropriate security standards during migration and conversation processes
- Verifies and documents conversion and migration results
- Produces entity relationship and dataflow mapping, database normalization schemata and data table models
- Evaluates and documents enhancements to ensure documentation is accurate and up to date
- Writes SQL statements and subqueries that use functions and selectively retrieve, sort, and calculate data, statistics, and values
- Designs data distribution and data availability and backup procedures
- Implements and confirms database replication
- Monitors and optimizes database usage
- Assesses network security threats and vulnerabilities
- Reviews logs and audit reports to identify and record security incidents, intrusions, or attempts
- Tests and verifies design performance and user permissions
- Tests database to ensure it functions according to specifications
- Communicates updates and issues with team members and clients in a professional manner, often in clear and non-technical ways
- Reviews platforms and environments for options and recommendations
- Completes the gathering of information necessary for the project accurately and free of conflicting requirements
- Develops models to be used to test the architecture
- Manages and supports legacy systems
- Optimizes database instances, partitions, and access for performance
- Analyzes and monitors server security and implement countermeasures (like patches and fixes) to address existing and potential vulnerabilities and threats
- Modifies existing databases and database management systems or direct programmers and analysts to make changes
- Delineates all components and interfaces to ensure a minimum of overlap and coupling between components of subsystems
- Updates the database code as new technologies emerge
- Uses computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information
- Validates data accuracy and integrity of migrated and converted data
- Develops and implements security and confidentiality protocols
- Tests the application to ensure functionality
- Validates user documentation to ensure it is accurate and up to date
- Identifies critical error areas to be addressed through modification
- Incorporates good database application techniques such as stored procedures, user developed functions, and triggers in the design
- Bases decisions on technical and business information, resources, and strategies
- Designs applications using application design tools
