DB Administrator Job Description
DB Administrator Duties & Responsibilities
To write an effective DB administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included DB administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
DB Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for DB Administrator
List any licenses or certifications required by the position: ITIL, DBA, SP, CC, PMP, MTA
Education for DB Administrator
Typically a job would require a certain level of education.
Employers hiring for the DB administrator job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Administration, Engineering, Science, Technical, Computer, Technology, Information Systems, Mathematics, Computing
Skills for DB Administrator
Desired skills for DB administrator include:
Desired experience for DB administrator includes:
DB Administrator Examples
DB Administrator Job Description
- Provide WebSphere SOA (IBM Broker/IIB, DataPower, WSRR, ) Administration and Engineering Support on multiple OS platforms in a multi-vendor environment
- Develop technical designs and policy/procedure documentation as assigned
- Install and configure MQ, Broker/IIB, DataPower, WSRR and FTE servers/agents
- Manage and patch middleware infrastructure and monitor performance
- Analyse problems and procedures to perform fine tuning to maximize performance
- Deploy new message flows, build MQ queue and channels, manage SSL keys
- Carry out pension administration tasks and calculations accurately and in accordance with internal processes and company policies, adhering to procedures and standards regarding work and conduct
- Draft correspondence and reports
- Check and authorise other administrators work
- Attendance at Trustee and ad hoc client meetings, including new business presentations as required
- Strong experience with business IT applications
- Use professional concepts
- Expected to understand and apply system management, performance timing and troubleshooting techniques
- Has solid foundation in many of the critical IT competencies needed to perform the job
- Document, configure, and implement OEM12c
- Oracle DataGuard install & Admin Security Plus Certification
DB Administrator Job Description
- Utilise web functionality for detailed DC transactional processing
- Utilise portal technology for administration automation
- Management of unit reconciliations/lifestyle switches
- Ensure client work is processed in timely manner and within target dates
- Prioritise work to ensure service level agreements are maintained
- Monitor transactional activity for Tariff and Fixed fee clients and ensure regular financial information provided to billing manager to ensure work is invoiced in line with the administration client service agreement accurately and in a timely manner
- Assisting team members as required and provide support to Team Leader /Operations Leader including deputising in their absence
- Deal with non-standard client/member queries
- Carry out such other duties and take on additional responsibilities as may be agreed from time to time
- To ensure timesheets and goal setting are completed in a timely manner
- Two or more years’ experience provisioning, operating, and managing AWS environments, specifically with S3, Spark, Scala, Data Pipelines, Redshift, DynamoDB and/or Aurora
- Solaris – 1yr + experience
- The ability to obtain and maintain a Government security clearance of Secret
- Knowledge of Oracle dictionary, internals, PL/SQL, SQL*Plus, RMAN, Database Control, SQL Developer, and CPUs
- Proficiency with Unix and Windows shell scripting, T-SQL, SQL Query tuning, System level monitoring and tuning, RMAN, Advanced Networking and security features, handling BLOB objects, support of Partitioning and Oracle Text, knowledge of Oracle database replication, standby and Data Guard
- Significant experience as a Middleware Administrator with WebSphere MQ, Broker/IIB, DataPower and WSRR experience
DB Administrator Job Description
- Assist with system testing for plan modifications and new plan implementations
- Set up user acceptance test case calculations
- Assist with training and mentoring of new employees
- Handle and support Production and Non production Oracle Databases
- Automate tasks using shell scripts
- Provide overall support and expertise on how best to leverage the Oracle DBMS and related tools and utilities for our test and production needs
- Plan DB environment according to the project needs
- Manage all installation and configurations of customer databases
- Maintaining smooth operation of multi-user computer systems, including coordination with network engineers
- Monitoring and managing system resources, including CPU usage, disk usage, and response times to maintain operating efficiency
- Experience with XML, XPATH and XSLT Transformations, SOAP Validations XML schema
- Experience with Data Power – Load Balancer, SSL and HTTP protocols
- Knowledge of Windows, AIX , and Linux OS operation and administration
- Proficiency in networking for connectivity across WebSphere ESB and Native OS
- Ability to coordinate triage teams for Production issues and resolution
- Define Best Practices for operational support, architecture, delivery, and software deployment with ESB architecture
DB Administrator Job Description
- Coordinating installations and providing backup recovery
- Developing and monitoring policies and standards for allocation related to the use of computing resources
- Design, install, configure, test and maintain middleware web services, database services, application software and management tools
- Manage and monitor installed services
- Proactively ensure the highest level of service availability in a 24/7 production environment
- Provide 3rd level support for middleware web and database services
- Maintain a proactive view on the performance of middleware and database platforms
- Conduct regular performance analysis and tune applications and databases to increase performance
- Enable automation
- Contribute to and maintain system/service standards
- Knowledge of DataPower V6 and above
- Experience migrating to cloud technologies desired
- Use existing processes and IT tools in place for change management, IT alerts)
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log issues, connectivity issues, security issues
- Oracle DBA/DB Developer experience
- At least 3 years of hands on experience in Middleware/Web/Database Administrator positions
DB Administrator Job Description
- Train 1st and 2nd level support teams
- Maintain topology, inventory and service specification documents
- Provide consultancy and input to solution design, pre-sales, service delivery
- Communicate technical and non-technical information to technical support groups, customer support centers and end-users as required
- Add/delete new users and access rights
- Modify/control underlying Foundation Data
- Modify/Create reports from the BSS constituent tools
- Review system performance logs
- Review Security logs provided by external Security Monitoring services
- Comply with extensive Security controls and policies in accordance with NIST 800-53 and other regulations governing BTFederal operations with the US Government
- Bachelor’s degree in Computer, Electrics/Electronics Engineering or related departments
- Expert in Microsoft IIS and .NET services design, implementation, maintenance, administration and troubleshooting in an enterprise environment
- Expert in Microsoft SQL Database Engine design, implementation, maintenance, administration and troubleshooting in an enterprise environment
- Experience with Microsoft SQL server components such as Analysis Services, Reporting Services and Integration Services
- Experience with Always On Failover Cluster Instances, Always On Availability Groups, Failover Clustering, Database Mirroring and Log Shipping
- Experience with Performance Tuning and Optimization (PTO), complex query tuning and schema refinement