Home | Jobs | Search

Position Detail

Organization: Conquest Tech Sol, Inc
Title: SQL/GIS Logical Database Administrator
Location: Atlanta, Georgia
Application Deadline:
Posted: 2017-05-01

Position Description:

Hi,

Hope you are doing well,

We are looking for a SQL/GIS Logical Database Administrator for a contract position at Atlanta, GA. Please review below job details and send me your most updated profile, Appreciate if you can refer your friends or colleagues who might be looking for a job.

Title: SQL/GIS Logical Database Administrator
Duration: 12 Months
Location: 2 Martin Luther King, Jr. Dr., S.E., Ste. 1452, East Tower Atlanta, Georgia 30334
Direct Client: State of Georgia
Req ID: # 52125

JOB DESCRIPTION:
Background:
The Georgia Environmental Protection Division (EPD) is the state environmental regulatory agency. Our mission is to protect and restore Georgia’s environment. EPD is seeking a logical Database Administrator (DBA) with extensive network administration experience to work on multiple application development projects across the Division’s Land Protection, Watershed Protection and Air Protection Branches.

Job Summary:
Works with EPD staff to significantly improve the application of technology across the institution. Assists in database design, process re-engineering, application development and the application of technology to significantly improve quality and efficiency in support of agency operations. Works closely with application development team members on the design, development, and implementation of a wide array of client- and / or web-based systems in support of current and future business processes; assesses reporting needs and builds and supports appropriate databases to facilitate effective use of data. Provides production issue triage support for migrated applications to a Cloud environment. Designs and secures computer databases to store, track, and maintain a large volume of critical business information. Develops database models, definitions and standards for administering databases. Makes recommendations for the migration of legacy databases to modern database environments, and implements as directed. Facilitates application and user access to data for input and output. Administers existing databases for applications. Works with agency business and technology staff and application developers to facilitate successful outcomes.
Technical Competencies:
• Experience working in information management, with emphasis on database administration, SDLC, systems integration, complex SQL queries, relational database concepts, data warehousing, data modeling, business intelligence and reporting solutions
• Planning and design of database functions and applications integrating existing and future systems
• Ability to research and design queries and reports; convert existing reports; develop new custom reports and interfaces
• Strong problem solving and analytical skills; ability to analyze user problems and recommend alternatives or solutions; ability to understand and communicate technical issues in a non-technical manner
• Experience in multiple technology environments including MS SQL, MySQL, Visual Basic, Microsoft Access, FoxPro, .Net, ASP, VBScript, Javascript, MS Office, experience with ESRI ArcGIS Server is a plus
• Experience implementing, managing and working in Cloud and SaaS environments is a must
• Strong organizational, multi-tasking, and time-management skills; the ability to plan and organize multiple projects and meet deadlines with quick turnaround

Job Responsibilities & Performance Standards:
• Able to perform job responsibilities with minimal supervision. Serves as a logical DBA, and interacts with third party providers of physical DBA role. Analyzes database problems and implements solutions within a reasonable timeframe. Reviews database for unexpected conditions as required. Develops ad-hoc queries to meet agency business requirements and to monitor potential or actual database integrity problems according to industry standards. Interacts with third party providers to ensure database recoverability. Ensures that back-ups of database structure and data are performed on a regular basis. DBA responsibilities require collaboration with third-party service providers.
• Serves as job expert or organization resource in assigned areas. Reviews requirements and gathers additional database object information from requestors as needed. Accurately and effectively uses database related catalog management tools to create database object definitions. Correctly creates or alters database objects. Administers appropriate security by coordinating access privileges for development staff and user personnel for database objects. Appropriately produces logical database designs, relative to systems development, implementation and troubleshooting as needed. Informs customers and programmers of testing processes and adequately discusses final products with pertinent parties before systems are fully implemented. Produces data models within project schedule using appropriate techniques. DBA responsibilities may require collaboration with third-party service providers.
• Develops and enforces utilization of object naming standards according to established guidelines. Effectively uses presentation skills when delivering and explaining data models enabling recipients to understand and use the models. Informs customers and programmers of testing processes and adequately discusses final products with pertinent parties before systems are fully implemented.
• Supports the installation and testing of new products and improvements. Plans production data migrations with appropriate personnel to ensure effective implementation. Produces detailed migration plan following required change control process. Some responsibilities may require collaboration with third-party service providers.
• Designs and modifies table structure, queries, automated data entry processes, and reports. Provides guidance and recommendations involving program modifications or upgrades that interface with database software as needed. Assists support personnel in establishing database parameters. Reviews and makes recommendations regarding database emergency disaster recovery readiness. Assists in developing interface requirements needed to utilize the database system and support tools when required. Carefully evaluates and makes timely recommendations on upgrades for database and products which use database. Participates in the preparation and presentation of training materials that provide appropriate educational instruction in the use and capabilities of database systems and related software tools. Ensures timely identification and resolution of database related software and hardware problems. Works with vendor and technical support personnel in producing documentation and other required problem-solving information in a timely manner. Some responsibilities may require collaboration with third-party service providers.
• Reviews the protection of vulnerable information. Reviews and analyzes proposed hardware and network changes which may affect database performance. Determines impact of changes and makes appropriate recommendations. Communicates impact of changes on database with appropriate personnel. Works to ensure that disruption of database services is minimized. Some responsibilities may require collaboration with third-party service providers.
• Implements measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Advises and assists programmers in coding and testing database requirements for programs according to established guidelines. Reviews programmers written database access language for efficiency and correctness. Obtains clarification from appropriate personnel when objectives of coded language are unclear. Answers questions and assists developers in a timely manner. Appropriately assists other staff members with complex queries and with analyzing queries for efficient database access. Some responsibilities may require collaboration with third-party service providers.
• Sets up and manages scheduling of updates and reports. Prepares standard query language (SQL) statements for use in programs as needed by programming staff. Obtains feedback as necessary to ensure accuracy of finished product. Tests code thoroughly as needed to ensure efficient and accurate results.
• Sets up processes for offloading data to external applications. Translates complex or technical information into a format that can be understood by others and distributed as needed. Incorporates knowledge of pertinent new trends and developments into procedures and makes recommendations for any related changes. Recommends Specifies access levels for each segment of the database. Communicates regularly with agency and third-party staff on progress toward defined goals and/or required results. Confers regularly with others to review specific problem areas and actions necessary for improvement.
• Tests programs or databases, corrects errors, and makes necessary modifications. Treats customers with respect, courtesy and tact; listens to customer and interacts with customer as a person while maintaining a business relationship. Communicates with customers and obtains all required information necessary to determine and address their specific needs. Provides clear, accurate information; explains procedures or materials or provides supplemental information; anticipates problems and questions.
• Responsible for creation/maintenance of administrator and user accounts, maintaining system documentation, tuning system performance, installing system wide software, allocating storage space, and backup recovery solutions/strategies.
• Responsible for the support and administration of network infrastructure and services, leveraging integrated technologies.
• Actively participate in security monitoring, managing, and testing, such as patches, updates, etc. and proactively address potential infrastructure issues before they occur.
• Support system development activities, to include performing routine system checks and maintenance of various EPD IT platforms and its dependent systems and applications, while ensuring consistency across the various platform environments.
• Maintains accurate and comprehensive documentation and diagrams of network infrastructure
• Will actively support the migration of EPD IT applications to a Cloud environment and will manage continuous delivery systems and methodologies including day-to-day configuration management and system management tasks associated with the applications and migration effort.



Thanks & Regards
Henry William
IT Recruiter | Talent Acquisition Team
Conquest Tech Solutions, Inc. | www.conq-tech.com
19 C Trolley Square, Wilmington, DE 19806
Phone: (302) 286-9010 Etx: 103 (Desk) | Fax: 302-288-6485
E: hwilliam@conq-tech.com | G-talk : henry.conquest17
I would greatly appreciate to be connected with you on LinkedIn Network.
LinkedIn: https://www.linkedin.com/in/henry-william-b8b084b7?trk=hp-identity-name

Disclaimer: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the organization. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.