Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Madison, WI
View more jobs in Wisconsin

Job Details

Database Administrator

Location
Madison, WI

Apply for this job






Profile

OverviewnThe Database Administrator is responsible for planning, creating, implementing, maintaining, troubleshooting and enhancing complex relational databases and the Enterprise Data Warehouse (EDW). This position consistently uses discretion and independent judgment to perform essential duties; including performance tuning, job scheduling, program processing and systems monitoring on an as-needed or as- instructed basis. This position advises management on database concepts, capabilities, performance improvements, and data utilization. n nThis position must effectively carry out the essential duties of this position in a manner that consistently demonstrates the core values of the organization in a positive manner.nResponsibilitiesn1) Develop, maintain and administer system databases and EDW - 45% na. Create logical links between databases to create EDW as required by the Credit Unionu2019s needs. This may be accomplished by utilizing various SQL tools.nb. Performance tune in-house and third party databases as required. This will include creating and re-organizing indexes, optimizing job schedules, and creating stored procedures and functions.nc. Plan, define, and create new databases using database normalization techniques to meet the Credit Unionu2019s needs.nd. Set up and maintain user security for databases and connected applications.ne. Interact with IT staff, appropriate UWCU division representatives and vendor support personnel to define and resolve systems-related problems. nf. Track and document actions and results in accordance with IT u201cchange controlu201d methodology.ng. Work closely with Project Managers, Programmers, and Web Developers to ensure a high level of database integrity.nh. Actively participate with IT Network, Operations, and Systems Programming staff in preparing and implementing backup and disaster recovery procedures and processes of mission critical databases.ni. Analyze and implement techniques to optimize system utilization, database performance and maintain established service levels.nj. Work with business units/data owners to classify database data for appropriate security, backup, and performance characteristics.nk. Generate automated, repeatable and stable processes to support data load, data validation, and data synchronizations for the Miser BI data warehouse. nl. Create database code requirements for all data warehouse data migrations and business unit and SQL-server projects via programming and the various SQL languages.nm. Identify and resolve data integrity issues between the data warehouses and the original data sources.nn. Create and maintain data dictionaries and database diagrams for complex in-house databases.no. Provide on-call support for problem resolution of database-related issues.n n2) Applications Development - 25% na. Provide applications development support primarily for data warehouse applications surrounding product development, marketing research, financial analysis and process improvements using programming tools or languages to support mainframe, platform, loan origination, interfaces and electronic forms systems, reports, and other PC-based applications.nb. Conduct needs assessment, program analysis and specifications, coding, testing, implementation, communication and documentation for all program development.nc. Explore and develop creative solutions and efficiencies through programming enhancements.nd. Maintain appropriate documentation of all changes and user-requested parameters and reports in accordance with IT programming standards. ne. Maintain updated documentation for application and system software and various utilities on a regular basis including the data dictionary for the data warehouse. nf. Coordinate all activities related to the operational plan, including maintenance of the status of requests for service, internal department assignments and documentation.ng. Modify and enhance third party databases and procedures to create an Enterprise Data Warehouse.nh. Lead projects of all sizes independently and, as assigned, work with Senior Programmer or Systems Programmer on large-scale projects.ni. Create, maintain, and document database views for client use in data warehouse reporting.nj. Maintain partnership with client liaisons (mainly the Finance Department) to impart knowledge and participate in client procedures and documentation.n n3) Software Maintenance and Support - 20% na. Implement new SQL server installations and update existing installations to ensure maximum security and efficiency.nb. Develop and implement proactive maintenance plan to review and install available third-party data transformation software fixes.nc. Actively lead and participate in new release upgrades of software and hardware.nd. Maintain data warehouse system parameters and security specifications.ne. Provide clients and staff with technical assistance for supported applications.nf. Manage Vendor Relationshipsnn Participate in new vendor evaluations, including contract negotiations as appropriate.n Ensure active usage of vendor provided resources, including technical support, education, compliance, reporting, and user groups.n Maintain professional rapport with vendor contacts to facilitate progress with problem resolution and new product enhancements.nn4) Other Job Duties - 10% na. Participate in Technology Division cross-training, including application development, data processing operations, network support and systems consulting.nb. Stay abreast of industry trends and continue to enhance technical skills through education, on the job training, reading, professional contacts and participation in user group meetings.nc. Assist and mentor Credit Union staff and programmers on database concepts, procedures, and data use.nd. Perform all other duties as assigned.ne. Back up fellow Operations Staff as needed by: nn Processing all regularly scheduled programs, including daily/nightly, monthly, quarterly, annual and periodic runs. Monitor messages and output for successful completion. Perform recovery/restart if necessary.            n Monitoring data communications; perform all tape/cartridge, printer and optical disk management.n Coordinating statement processing, and special reporting such as IRS and year-end activities.n Performing System Administrator duties for Optical Disk document storage system.nn nQualificationsnTo perform this job successfully, an individual must demonstrate regular, predictable attendance and be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Be available for problem solving during non-regular work hours, including on-call support.n nEducation: n-Bachelors degree in Computer Science or related field requiredn nExperience: n-Expert knowledge of current supported versions of MS SQL Server. n-6-7 years of database programming and software maintenance experience in a SQL environment, including working with end users. n-Detailed understanding and experience with relational database modeling concepts, including the use of Primary Keys, Unique Keys, Foreign Keys, Triggers, Views, Stored Procedures, Table Joins, Normalization and Entity Relationship Diagrams.n-Detailed understanding of SQL performance tuning techniques and tools.n-Experience with SQL data transformation tools.n-Demonstrate analytical, problem-solving and leadership skills.n-Expert in all MS Office products. (Excel, Access, Word).n-Excellent interpersonal skills.

Company info

Sign Up Now - DBACrossing.com

Similar Jobs:
SQL DBA/System Analyst
Location : Madison, WI
See more jobs like this SQL Database Administrator Primary Location - Fitchburg, Wisconsin V-Soft Consulting is an end-to-end recruiting and staffing solution provider known for our ability to provide highly qualified consultants ...
Database Administrator
Location : Madison, WI
Database Administrator Robert Half • Madison WI Job #710128000 Robert Half Technology is looking for a Database Administrator who loves the challenge of solving problems with multiple layers of complexity. This may be the position...
What I liked about the service is that it had such a comprehensive collection of jobs! I was using a number of sites previously and this took up so much time, but in joining EmploymentCrossing, I was able to stop going from site to site and was able to find everything I needed on EmploymentCrossing.
John Elstner - Baltimore, MD
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
DBACrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
DBACrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2018 DBACrossing - All rights reserved. 168