Senior Administrator, Database Job Description
Senior Administrator, Database Duties & Responsibilities
To write an effective senior administrator, database job description, begin by listing detailed duties, responsibilities and expectations. We have included senior administrator, database job description templates that you can modify and use.
Sample responsibilities for this position include:
Senior Administrator, Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Senior Administrator, Database
List any licenses or certifications required by the position: SQL, MCTIP, DBA, MCSE, MCSA, ITIL, MCDBA, AWS, II, IAT
Education for Senior Administrator, Database
Typically a job would require a certain level of education.
Employers hiring for the senior administrator, database 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 Administrator, Database
Desired skills for senior administrator, database include:
Desired experience for senior administrator, database includes:
Senior Administrator, Database Examples
Senior Administrator, Database Job Description
- Maintain responsibility for all aspects of database administration such as maintaining, monitoring and troubleshooting databases hardware/software/interfaces and performing bug fixes and security patches
- Provide support and assistance to the development team in the design, development, testing, tuning and implementation of database applications
- Assists AFTAC/TT in testing in-house and third party software that interacts with the databases
- Manage a production environment consisting of 600+ Oracle / Microsoft databases across 50+ database servers
- Complex problem solving skills in other Database technologies MySQL/MSSQL/Oracle
- Experience with Oracle Enterprise Monitor and Zenoss Enterprise Monitoring
- Project delivery/management with internal resources or via external managed vendors
- Manage BAU support processes
- Collaborate with internal teams, stakeholders and management on the development of technology solutions
- Monitor database jobs
- Expert knowledge in T-SQL with knowledge in NoSQL database technology is a plus
- Experience in setting up and maintaining production Oracle RAC environments
- Extensive experience with Windows operating systems
- Ability to work well under pressure and multi-task several issues at the same time
- The ability to provide clear and prompt communication flow concerning client issues between client, staff and management
- Must participate in DBA team afterhours and on-call rotation
Senior Administrator, Database Job Description
- Maintain efficient and sustained operation of enterprise class systems, including coordination with networking staff, security staff, storage engineers, and other systems administrators
- Analyzes and recommends capacity planning (SAN storage) based on captured growth trends and monitoring
- Design, implement and maintain database security based on company policy, best practices and any regulatory requirements
- Go-to technical resource as it relates to database physical data storage, maintenance and security
- Evaluate and recommend database related software products within technical architecture framework
- Develop and execute procedures for database maintenance, backup, archiving, mirroring
- Manage the database security models, both in-house developed Windows Auth (AD) based security
- Designs, implements and supports current company data
- Proven track record with a minimum of 5+ years of DBA experience
- Solid experience in MongoDB and Cassandra
- Experience with database replication technologies in a production environment required
- Experience with database deployment technologies dbMaintain/Flyway/Liquibase desired
- Experience with DevOp's practices and tools desired (Chef/Vault/Consul)
- Experience working with vendor support organizations
- Oracle 12 C version
- Unix, Perl or Shell nice to have
Senior Administrator, Database Job Description
- Maintain user database accounts, performing database back-ups and restores, and providing internal database training to end-users
- Proactively monitor 24/7 mission critical servers
- Installation and configuration of new databases instances when necessary, and conducting upgrades and patch applications when appropriate
- Provide solutions to development teams when proposed architecture does not comply with architectural, performance or security guidelines
- Resolve database performance issues using all available tools and take corrective actions when necessary
- Work with the development teams to ensure a solid understanding of the application and database requirements exist and configure database structures and parameters accordingly
- Communicate to business customers, technical teams and management in a consistent manner making complex technical issues and solutions clear, simple and understandable
- Possess overall understanding of IT architecture, infrastructure standards, database platforms and programming languages and tools
- Demonstrate a thorough understanding of Data Management philosophies and apply them to existing and to-be architectures
- Ability to produce clear documentation around reoccurring processes
- Knowledge and hands-on experience of MS SQL Server, My SQL on-board tools and 3rd party DBA tools and applications
- Performance tuning, code optimizations
- Experience working with high scale VLDB OLTP and OLAP databases
- In depth knowledge of database design, optimization, and normalization techniques
- Ability to make decisions and work well in high pressure situations
- Determine user requirements, set up and test computer databases, and coordinate changes
Senior Administrator, Database Job Description
- Perform daily system monitoring (using alerts, automated scripts, log reviews, ) to verify the integrity and availability of all hardware, server resources, systems, and key processes
- Works closely with clients, business analysts, systems programmers, and application developers to define and resolve information flow and content issues---helping to transform business requirements into environment specific databases
- Selection, design and tuning storage systems for reliability and performance
- Provide database support 24/7/365 for production environments (based on rotating schedule)
- Define, recommend, and develop database standards, procedures and architecture
- Keep stability and reliability of a databases proactively react to data growth / risks / issues
- Implement enterprise database standards across the portfolio of databases
- Demonstrate very strong problem solving and communication and must be willing to work with several product lines on several assignments concurrently
- Oversee and coordinate support and project activity for 3rd party vendors
- Develop new or maintain existing databases based on various projects and operational specifications
- 6+ years of SQL Server 2008/2008 R2 with knowledge in SQL Server2012
- 5+ years of experience as a database administrator (DBA), including administering user accounts, performing database configuration, database management, and software installation and performing backups, configuration management, and general database system maintenance
- 6 to 8 years of progressive experience as a DBA on the Microsoft SQL Technology Stack
- Knowledge of Data Warehouse, BI, reporting tools, Oracle Data Base Administration, ETL, Data Architecture Design and Development Administration and Performance management tools
- Proven ability to deliver on high priority business goals
- Art Cloud
Senior Administrator, Database Job Description
- Provide daily operational support for SCADA SQL environment
- Lead the discussion and work with team members to identify performance bottlenecks, tuning of both SQL statements and tuning the RDBMS software, and have the knowledge to recommend models, create physical schema structures, maintain user connectivity, and provide adequate security as required
- Install SQL on newly built servers, apply patches as needed, create/configure all database maintenance jobs
- Create and maintain all databases required for development, testing, and production usage
- Perform server upgrades and new version implementations
- Writing database documentation, including procedures and processes metadata
- Operational support of multiple technology platforms
- Conducting investigation across any system component and related systems to discover and rectify performance bottlenecks and sources of unreliability
- Applying scientific principles of experimentation and measurement to system components to identify improvements to the configuration and architecture which improve reliability, performance and operability
- Provide technical leadership and supervision to Database Administration team
- Minimum 2-3 years of professional Azure SQL or SQL Server Administration experience
- A minimum of a Bachelors or other applicable degree
- 5 years’ experience administering database environments and utilizing industry standard tools, technologies and best practices
- Excellent communication skills (written and oral) are required along with interpersonal skills to allow effective interaction with DBA’s, developers
- Proven skills working with complex technologies ( Oracle RAC, ASM, DataGuard, Oracle E-Business Suite performance tuning and Informatica)
- Extensive knowledge of Linux and Solaris operating systems