Senior Database Administrator Job Description
Senior Database Administrator Duties & Responsibilities
To write an effective senior database administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included senior database administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
Senior Database Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Senior Database Administrator
List any licenses or certifications required by the position: SQL, MCTIP, DBA, MCSE, MCSA, ITIL, MCDBA, AWS, II, IAT
Education for Senior Database Administrator
Typically a job would require a certain level of education.
Employers hiring for the senior database administrator job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Information Technology, Administration, Technical, Information Systems, Mathematics, Business, Management
Skills for Senior Database Administrator
Desired skills for senior database administrator include:
Desired experience for senior database administrator includes:
Senior Database Administrator Examples
Senior Database Administrator Job Description
- Ensure Image copies are processed in a timely fashion for effective and timely recovery, both local and remote
- Monitor DBRC and databases status regularly
- Proficient with IBM IMS & DB2 utilities and BMC tools
- Proficient in database performance and tuning
- Define and create IMS DB and DB2 objects
- Perform functions such as PSBGEN, DBDGEN and ACBGEN
- Provide on-call support for IMS and DB2
- Set up, schedule and troubleshoot utilities such as Image Copies, Reorgs, Runstats, Binds, Unloads, Loads, Recovery
- Participate in incident and problem management activities related to application, IMS and DB2
- Support internal and external projects simultaneously with releases
- Basic knowledge of financial system processes, including familiarity of relational database concepts, and client-server concepts
- Law firm or professional services experience is a plus
- Managing OLTP systems with high uptime
- Performance monitoring and tuning, capacity planning
- ETL Processes with SSIS, &, SSRS
- Proactive approach to database design, development, and management
Senior Database Administrator Job Description
- Provides technical expertise for installation, configuration and operation of MS SQL servers
- Performs administration and monitoring of the assigned MS SQL servers
- Applies best practices to enable stable MS SQL operation
- Performs necessary patching and updates of the MS SQL servers
- Database health and performance monitoring
- Work alongside Architecture and Development teams to ensure product scalability and performance
- Design, implement and modify physical database structures
- Ensure highest standard of systems, database and platform requirements related to capacity, performance, integrity, and recovery
- Ensure data security, integrity and access control as per auditing standards
- Responsible for the management and maintenance of back-ups and recovery procedures
- Bachelor’s degree in Computer Science, Information Technology, or Business or equivalent OR High
- Bachelors Degree or High School diploma with 8+ years equivalent work experience
- 6+ years running database services at scale
- Strong knowledge of MySQL best practices
- Experience in online schema updates
- Experience in MS SQL, PostgreSQL and Cassandra would be an added advantage
Senior Database Administrator Job Description
- Good knowledge and experience in scripting languages (Bash, Korn, Perl, Python)
- Understands the competitive landscape from both a business and technical perspective
- Mentors more junior DBA and intern/co-ops
- Assists and develops internal DBA standards
- Ensures that all databases are backed up, conducts restore tests
- Improves and automates regular processes, documents changes to the systems
- Supports software developers by assisting in troubleshooting technical problems
- Follows strict change control procedures
- Interact with users, software developers, database administrators and evaluate vendor products
- Configure administrator accounts, maintain system documentation, tuning system performance, installing system wide software
- 3+ years experience with other RDBMS platforms such as Oracle, SQL Server or Postgres in a production environment preferred
- Experience with other RDBMS platforms such as Oracle, Sybase, SQL Server in a production environment preferred
- Experience designing data queries against data in the HDFS environment using tools such as Apache Hive, Implementing MapReduce jobs
- Hands-on knowledge of Map-reduce, Pig, Hive, Flume and other tools such as oozie, zookeeper etc
- 5 + years administering multiple MySQL databases and versions
- Advanced understanding of explain plan and sql statement tuning
Senior Database Administrator Job Description
- Monitor and resolve database performance issues, database capacity issues, replication, and other distributed data issues
- Install and maintain new DBMS versions (currently MS SQL Server 2012 and 2014)
- Design, implement, manage, and tune SQL Server HADR (including Mirroring, Log Shipping, and ALWAYSON)
- Database performance tuning, implementing backup solutions and capacity planning
- In this role, you will be on a small data services team which oversees all regions , development, production
- Establishes policies and procedures related to data security and integrity and monitors and limits database access as needed
- Oversees the design, maintenance and implementation of the systems that manage an internal database
- Work closely with business stakeholders to help define and execute requirements
- Ensures that all databases are maintained properly in order to maximize performance of all database applications
- Ensures solutions meet business objectives and establishes and maintains a high level of user trust and confidence
- Database administration in Oracle /UNIX environment
- SQL and/or Oracle Server certifications
- At least two (2) years of programming experience with web development technologies, such as PHP, HTML, CSS, JavaScript, and JQuery required
- Ability to conduct Section 508 accessibility testing and address gaps
- Working knowledge of conducting unit and application testing
- Experience in software release and deployment processes
Senior Database Administrator Job Description
- Act as DBA resource in different projects working with all different IT and business teams, internal and external to Atlas, on all stages of the SDLC
- Work with business units and application/development teams to build and implement data models and database designs
- Manage backup and recovery of databases
- Maintain database changes from Development to QA to Production
- Develop, document, and maintain data, database, and system standards
- Write and execute policy and procedure to ensure data integrity and adhere to Sarbanes-Oxley requirements
- Manage, administer, and support SSMS, SSIS, SSRS, and SSAS
- Develop detailed and thorough knowledge of database schema, database operations and database communication layers
- Work with team to enforce database standards
- Designs, installs, maintains and upgrades the enterprise’s production databases
- Based platforms that enhance DevOps and data analytics capabilities of a US national agency
- Knowledge of variety of Databases including SQL Server or PostgresQL
- Understanding of NOSQL Databases including MongoDB
- 6 + years experience with Database Administration and development, particularly Oracle and SQL databases
- As a Senior Database Administrator you will Support, Administer, Manage, and Tune the multi-terabyte Database Systems that will enable S&P Capital IQ to ingest, manage, process and serve-up Market Data Products (Global Risk Solutions, Pricing, Ratings & Financial Aggregates) our highly transactional and dynamic web based CIQ Platform & Credit Solutions Portal
- Improve efficiency and quality of delivery by automating routine tasks