Job Title (Date):
Database Administrator (September 2024)
Department:
Information Technology
Employee Type:
Full-time
Reports to:
Manager – IT Application Development
FLSA Status:
Exempt
Travel Required:
None
Supervisory Responsibility:
None
Salary Range: $96,561-$144,841
Posting Period:
September 24, 2024 - October 7, 2024
*Typically, initial wage is set between the minimum and the midpoint of the salary range depending on the employee’s qualifications and experience. Summary of Responsibilities:The Database Administrator is responsible for supporting SERS through continual research and analysis of database products, architectures, trends, and all activities involving relational database(s), windows failover clustering, and SQL availability group administration. Supporting the application development efforts by proactively providing expertise in database design and implementation.
Supporting the operational environment by ensuring appropriate policies and procedures exist to protect, secure, and administer data/databases and governance occurs accordingly. The Database Administrator will collaborate with key IT staff to administer and control activities related to the analysis of database requirements, data planning, data development, and data management. The Database Administrator will also collaborate with key IT staff to ensure consistency and integration with existing structure within databasesEssential Duties and Responsibilities:
- Create, maintain, and update project plans for database administration work.
- Administer SQL and PostgreSQL databases on Windows operating systems.
- Advise on RDBMS structure and review database designs.
- Analyze and design data usage using data modeling techniques.
- Evaluate and approve system analysis and design for optimal database structure and access.
- Define, recommend, and implement database performance mechanisms.
- Develop the security architecture and plans for databases and data.
- Establish and maintain standards for databases, data, and data access.
- Coordinate activities involving database related product vendors.
- Establish policies and procedures for management, security, maintenance, and utilization of corporate databases and data.
- Design, develop, test, implement, maintain, and execute backup, archive, recovery, and loading strategies and procedures.
- Design, develop, test, implement, maintain and execute plans and procedures to protect and continue accessibility of data, including emergencies and disasters.
- Data Encryption
- Windows Cluster and SQL Server Always-On Process
- Develop budget requirements for maintenance support, upgrades, enhancements and additional database related tools.
- Automate Pension Administration System Operations (e.g., batch processing, post processing cleanup, etc.) to optimize their runtime and drive efficiency, including monitoring, and alerts.
- Evaluate Pension Administration System operational data growth (file systems, data base, etc.) and implement a technical solution to properly manage and limit data growth.
- Gain understanding of the Pension Administration System application eco-system (e.g., PlanetPress, Workflow, Imaging, SFTP, Centralized Printing, etc.) and take ownership for ongoing caring and feeding, including product lifecycle management.
- Perform troubleshooting activities that support the Pension Administration System business application performance, uptime, and related issues (e.g. code, SQL, PowerShell script, data fix, etc.).
- Proactively maintain database operability, including the implementation of physical views to optimize performance and eliminate data redundancy.
- Utilize ServiceNow to effectively track project time and manage ticket workflows.
- Conduct thorough research of data sources to enhance data feed quality and reliability.
- Monitor database size and space utilization to ensure optimal performance and prevent bottlenecks.
- Implement continuous monitoring and improvement strategies to enhance data performance and efficiencies.
- Employ appropriate software packages to safeguard data integrity and security.
- Mentor and train first and second-level help desk personnel on the use of software tools supporting database operations.
- Provide afterhours technical support as required by the needs of the organization
- Support third party software products and interfaces
- Other responsibilities as assigned.
The incumbent is required to:
- Carry cell phone with text messaging capabilities to respond to daily business needs.
Education, Skills and Qualifications:
- Bachelor's degree (B.S.) in computer science or related field; or three to five years related experience and/or training with:
- Expertise in managing MS SQL Server databases.
- Knowledge or experience in C#, ASP.NET, JavaScript is a plus.
- Exceptional troubleshooting and problem-solving abilities for database-related issues.
- Three years’ experience with Power Shell or other scripting language.
- Three years’ experience in IT operation (FTP, batch etc.) management.
- Demonstrates personal accountability in work and personal actions, following through on all commitments.
- Ability to adapt and change behavior or methods of approach in rapidly changing environments.
- Demonstrates strong attention to detail skills through thoroughness and thought of work products.
- Capable of understanding situations and problems, by combining information. Able to identify patterns and connections conceptually and apply information to identify underlying issues in complex situations.
- Demonstrates eagerness to continuously learn and acquire necessary technical knowledge, skills, and judgment to accomplish results or to serve a customer's needs effectively.
- Competence in collecting, consolidating, and correctly using relevant data; recognizing important information. Developing proper analysis and tracing possible causes of problems; searching for practical data/solutions.
- Ability to spot opportunities within your own circle of influence, anticipating threats and acting on them; demonstrating the ability to be a self-starting rather than waiting passively until the situation demands action.
- Builds and maintains ongoing, collaborative, working relationships with coworkers to achieve the goals of the work unit.
- Demonstrates effective planning and organizing skills, with ability to set priorities and define realistic actions, time and resources needed to achieve predefined goals. Consistently delivers required business results; sets and achieves achievable, yet aggressive, goals; consistently complies with quality, service and productivity standards and meets deadlines; maintains focus on SERS’ goals.
- Ability to express ideas and opinions clearly in properly structured, well organized, and grammatically correct reports or documents, utilizing language and terminology that is understandable for the reader.
- Ability to use strategic awareness to put things in context and to think broadly. Considering and understanding future business needs within a changing external environment and how process, methods and resource requirements might be affected by future trends and developments, and of developing long-term goals and strategies extending over significant time span (i.e. 3-5 years).
- Equivalent combination of education, skills, and experience
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills, and abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Working Conditions:
This role operates in a professional office environment and is subject to prolonged periods of sitting or standing at a desk and working on a computer. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines and may need to be able to lift up to 10 pounds at times. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.
ERM staff members are eligible to work remotely 2 days per week, after training and 30 days of employment. Remote working days are not guaranteed and subject to change based on organizational needs. Competencies:
SERS Specific:
Focus - Dedicated to meeting the needs of customers both internal and external. Talks, acts, and makes decisions with customers in mind. Accountability - Takes responsibility for all work activities and personal actions; follows through on commitments, implements decisions that have been agreed upon; maintains confidentiality with sensitive information; acknowledges and learns from mistakes without blaming others. Recognizes the impact of one’s behavior on others.Communication - Creates an environment of open, direct and proactive communication, both written and verbal.
Is unafraid to communicate freely across layers of the organization.Collaboration- Develops cooperation and teamwork while participating in a group, working toward solutions which generally benefit all involved parties.Innovation - The commitment to search for and create new and innovative approaches to activities that enhances performance. Is willing to change. Note: While performing the duties of this job, the employee is regularly required to sit, stand, walk, and lift up to 10 pounds. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate. SERS is an equal employment opportunity employer.Disclaimer: This job posting is not meant to be all-inclusive and the position itself is subject to change.SERS is an Equal Employment Opportunity Employer. We recruit, hire, train, and promote without discrimination due to age, race, color, religion, sex, sexual orientation, national origin, citizenship, disability, military leave or veteran status, genetic information, or any other status protected by applicable federal, state or local law. SERS is committed to ensuring all applicants can successfully submit an application for consideration. If you have a disability, and you wish to discuss potential accommodations to complete your application for employment, please call (614) 340-2255.
SERS does not accept unsolicited recruiter and agency resumes and will not pay fees to any third-party agency or company that does not have a signed agreement with SERS.
96561.00 To 144841.00 (USD) Annually
