This is a dual purpose role for a small/medium sized organization. Ideally looking for an individual to function as the backup database specialist but also serve as the SME for the security/cloud operations for the organization.
As a Database Administrator is primarily responsible for the health, maintenance, backup and security of the various databases and supporting developers with database expertise regarding data architecture, SQL construction, application/database integration, and creation of test environments. These databases (Oracle, MySQL and SQL Server) reside physically in the building and in the AWS cloud.
ESSENTIAL DUTIES and RESPONSIBILITIES:
•Develop, test, maintain and document changes to databases, both internal and public facing.
•Assist developers and others in the department with database related needs.
•Perform customer support for applications as needed.
•Monitor health and security of the databases.
•Develop and maintain queries and complex reports as needed.
•Develop, debug and maintain procedures, functions and other DDL as needed.
•Develop ETL code and plans.
•Perform other duties as assigned.
An individual in this position must be able to successfully perform the essential duties and responsibilities listed above. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.
Education and Experience Required:
•4+ years of experience working on progressively more complex systems.
•PL/SQL, Transact SQL, SQL 92 or other database language required.
•Familiarity with scripting languages.
•Familiarity with Linux.
•Familiarity with Agile development principles.
•Strong work ethic, professional, organized, and flexible; able to work independently to solve issues through self-directed research and troubleshooting.
•Ability to handle and prioritize multiple tasks.
•Bachelor’s Degree or relevant work experience.
•Design and development of database functions, procedures and packages.
•Experience with reporting tools such as Crystal Report.
•Experience working in a team environment.
•Experience with modern systems development model.
Provides professional technical services and end-user support on a wide array of systems and software applications via telephonic, electronic, and in-person contact. Performs a wide range of IT support tasks using strong customer service, troubleshooting, and documentation skills. This position requires the ability to work with users and assist them in their use of technology.
General Help Desk support for external users:
Perform Help Desk telephone and email support for users of our public facing web applications. Resolve issues which primarily relate to account creation, account management, and application use. Use established guidelines and own judgment in determining priority of each call, and identifying issues that require escalation. Maintain records of support, and update Help Desk documentation as needed.
General Help Desk support for internal users:
Perform Help Desk support for fellow users at our Madison, Wisconsin office. Resolve typical support and training issues related to account management, applications, and end user hardware. Supported applications include but not limited to MS Office suite (Outlook, Word, Excel, and SharePoint), Adobe Acrobat Pro, Windows XP, Windows 7, and custom in-house applications. Perform general hardware support such as set-up, maintenance, and updates of user workstations and peripherals.
Other miscellaneous duties include
Bachelor’s Degree or relevant work experience.