Madison Gas & Electric Database Administrator in Madison, Wisconsin
Job Category Information Technology
# of openings 1
Apply Now (https://phf.tbe.taleo.net/phf01/ats/careers/v2/applyRequisition?org=MGE&cws=38&rid=1589)
DUTIES AND RESPONSIBILITIES
Under general direction, provide advanced analytical and technical support in designing, implementing, and supporting database systems.
Plans, reviews, and performs the implementation of database changes.
Designs, develops, documents, and implements database jobs including backup and recovery strategies and procedures. Reviews periodically for effectiveness. Identifies, recommends, and implements changes.
Provides in-depth database support by identifying complex database problems related to user data access issues, recommends solutions, and implements as needed.
Assists in developing and delivering database training.
Assists in designing, developing, and implementing database capacity reporting procedures and tasks. Documents, monitors, and identifies hardware capacity requirements and implements changes. Forecasts database capacity needs.
Monitors, investigates, and reports performance issues. Evaluates, recommends, and remediates performance issues identified in performance reports.
Assists in developing documents and procedures for maintaining information related to database systems including data retention, archival schedule, etc.
Assists in developing, defining, and documenting naming standards, usage standards, etc., and establishes rules for defined data security.
Recommends, reviews, and implements database design and definition changes, meeting application requirements while ensuring database access performs within acceptable levels.
Enhances application development processes and system performance by performing application code reviews.
Evaluates, installs, tests, and maintains database software including applying maintenance, hotfixes, and APARs.
Education and Experience
Associate degree or equivalent experience.
Two to three years of relevant experience.
Knowledge and Skills
Knowledge of Oracle 12c/19c preferred.
Oracle container databases, RAC, Active Data Guard, Oracle Enterprise Manager experience.
Knowledge of Oracle Fusion preferred.
Knowledge of Oracle Data Integrator preferred.
Able to recognize and analyze complex problems, develop remediation recommendations, and implement appropriate solutions.
Excellent organizational and planning skills.
Excellent written and oral communications skills.
Good human relations skills necessary for clear communication with supervisor and peers and cooperative relationship with interdepartmental personnel.
Knowledge of systems design and analysis techniques, routine testing and debugging procedures, and documentation methods.
Knowledge of database design, naming standards, and database data access methods.
Knowledge of database structures and their implementation.
Data Warehousing, large database concepts and practices preferred.
Familiarity with Microsoft SQL, replication, Always-On Availability Groups, monitoring, performance tuning a plus but not required.
General coding knowledge, database projects, source control, SQL server Integration Services knowledge a plus.
If you are interested in applying for this position, click on "Apply for this Position" below. However, if you are already logged in, click on the "Add To My Jobs" below.
AA/EOE-Minorities/Females/Gender Identity/Sexual Orientation/Disabled/Vets