Database Administrator II
HYBRID in Lake Mary, Florida
Fully Remote Candidates will not be considered
Current Green Card Holders or US Citizens Only
Database Administrator II is a function that together with the Database Manager will manage all aspects of database operations. As a Database Administrator II, you will manage all range of RDBMS in highly available environment both on Prem and in AWS.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Provide overall database administration & system tasks, support & maintenance
Undertake monitoring/ tuning / optimizing, installation, updates, upgrade, and backups/restore/recovery processes, etc.
Carry out periodic database maintenance & systems support
SQL Server and PostgreSQL database design, system analysis & architecture design
Action incident and problem management activities, escalating issues to external technical support parties when required.
Supply database statistics & related data on a timely basis
From time to time, support team members with data analytical and other application support activities
Manage operational tasks such as providing technical support for ETL processes, SQL Agent Jobs, and support Application release
Problem-solve issues (connections errors, databases & their operating systems) as and when they arise
Produce & maintain technical & user documentation
Issue tracking and change through agreed business systems
Working with other DBA and Infrastructure team, design and facilitate database backup and recovery as well as document and test all backup and disaster recovery procedures
Provide development and production support to troubleshoot day-to-day database or related application issues
Maintain and administer database security access
Manage DBA related projects within the organization
Provide input into IT Risk Management function, working closely with DBA Manager/Risk Analyst
Participate in Data Governance strategic development.
On-call requirements to ensure 24 x 7 support of database operations
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Strong organizational and documentation skills. The requirements listed below are representative of the knowledge, skill, and/or ability required. IT also must have:
5+ years’ experience as a database administrator in SQL Server and other RDBMS environments performing the Essential Duties required for this position
Experience with Monitoring & Diagnostic tools
Experience working with Windows server and Linux environment, including disk configuration
Proficiency in SQL Server and PostgreSQL database design, system analysis & architecture
In-depth knowledge of Microsoft SQL Server and SSAS/SSIS/SSRS technologies
Able to create and update PowerShell and Linux scripts
Competency with SSMS and T-SQL knowledge to create data queries and data extracts
Knowledge of AWS or other cloud platform
Experience with Microsoft Clustering and SQL Server Always On High Availability
EDUCATION and/or EXPERIENCE
Bachelor’s degree in information technology, computer science or equivalent combination of education
CERTIFICATIONS
MCSA SQL Server
MCSA Database Administration
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Strong organizational and documentation skills. The requirements listed below are representative of the knowledge, skill, and/or ability required. IT also must have:
5+ years’ experience as a database administrator in SQL Server and other RDBMS environments performing the Essential Duties required for this position
Experience with Monitoring & Diagnostic tools
Experience working with Windows server and Linux environment, including disk configuration
COMPETENCIES
Problem Solving
Quickly analyses work problems and implements solutions
Uses his or her technical knowledge to solve business problems
Has a good knowledge of the practical issues within his or her team
Supports the technical crises or problems that occur in his or her team
Consulting
Listens to staff input when making decisions
Draws on the advice of others when making decisions
Supporting
Spends time with team members talking through issues or concerns
Helps others in a patient and supportive manner
Planning
Plans work activities and initiatives well in advance
Has plans in place to deal with future contingencies
Considers the long-term impact of his or her actions
Monitoring
Closely monitors his or her own performance relating to specified goals
Complies with required procedures and work processes
Provides progress reports to team leaders and management as needed
Performance Attributes
Excellent written and oral communication and interpersonal skills
Results orientated
Ability to work comfortably with competing demands & finite resources