SQL DBA/Application Consultant

Company: Amzur Technologies, Inc.
Location: Novi
Posted on: March 14, 2020

Job Description:

Title SQL DBAApplication Consultant Location Novi, MI Duration 6+ Months Position Description Under general supervision, the Database Administrator, Application has the overall responsibility of the activities related to the design, planning, administration, maintenance, support, and documentation for databases connected to a specific application or applications. This individual is an expert at writing and debugging complex SQL statements and understands the best ways to incorporate database requests into different applications. She is proficient at working at the highest level with all aspects of database administration, design, development, and database management system software (DBMS). Requirements Bachelor's degree or equivalent Computer science, information systems or equivalent experience Four (4) years of experience in database administration ADDITIONAL REQUIREMENTS Excellent verbal and written communication skills Analyze and solve problems Interact with employees at all levels of the organization Detail-oriented Guide, engage and impart knowledge to others Aptitude to learn new software and hardware System analysis and database design skills Physical storage and data security skills Back up and recovery skills change control management skills Knowledge of database design, file access methods, data standards, data control, data security, data modeling, and normalization Knowledge of backup and recovery issues pertaining to database platforms Proficient in the database and relational database systems in general Proficient in one or more of the following Oracle, SQL, Netezza, Greenplum, or other Knowledge of how different programming languages and frameworks interact with databases Expert in Structured Query Language (SQL) Performs other duties as assigned Responsibilities Administers and supports data structures used to store or reference data (DB objects) Data objects include tables, indexes, sequences, stored procedures, views, and others. Ensures optimum performance of these db objects and queries Manages, supports and tests the application connectivity to the applicable database(s) Supports deployment of database application code to the production environment Designs and maintains the application level monitoring solution(s) related to databases Assists developers in the tuning of SQL statements to reduce the response time for users and reduce the resources used Defines the content and structure of the database and advises users on efficient techniques to extract data. May extract data from different source systems and load data extracted into the targeted database Identifies and evaluates database requirements for specific applications and determines the efficient interaction for proposed solutionsfunctionality Requests and maintains application service accounts Provides on-call support, solutions, and guidance for database related application(s) inquiries, requests, and problems Collaborates with project teams in all aspects of product evaluations, design review, data requirements, and application development projects recommends and evaluates software and hardware solutions If any one interested please reach me out aravind(dot)pothula(at)amzur.com

Keywords: Amzur Technologies, Inc., Novi , SQL DBA/Application Consultant, IT / Software / Systems , Novi, Michigan