JOB SUMMARY: The Sr. SQL Database Administrator is accountable for delivering high quality database management systems and administration of those systems. This position is responsible for the design, implementation, development, performance, optimization, monitoring, availability, security, testing, maintenance, database technologies at GSF. This position is primarily focused on the development of steady and reliable information systems of the enterprise. A primary responsibility will be that the person will optimize our existing database platforms, and make it scalable to encompass data for all entities within the GSF portfolio. Capable of managing remote workers.
Salary is DOE, starting at $110k. This role is bonus eligible.
ResponsibilitiesESSENTIAL FUNCTIONS
(% of time may vary depending on assignments/projects)
1. Database Administration Duties
· Drive database optimization by engaging with software vendors to identify poor queries.
· Optimize and tune high transactional database systems engaging with application team.
· Monitors database performance and implements changes to tune performance.
· Works side by side with applications team to optimize application performance.
· Establishes physical database parameters.
· Work closely with the applications teams to maintain a data dictionary
· Calculates optimum values for database parameters.
· Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data.
· Tests and corrects errors and refines changes to database.
· Work with development teams and analysts to make changes to the database.
· Establish standards for database systems and database security.
· Works with the Business analyst to help create test plans to ensure the sustainability of any production release.
50%
2. Business Information Requirements
· Works with the users and enterprise architect to develop and maintain databases and determine the best ways to organize and store data.
· Understand the information requirements of the systems and coordinate the development and / or maintenance needed to satisfy further processing and retrieval of information.
· Ensure the performance of the systems understands the platform on which the database runs and develop the standards for data elements and relationships.
· Has the ability to communicate business requirements into technical requirements.
· Works within the defined project methodology within the GSF IT organization.
20%
3. Business Information Design
· Designs logical and physical databases or reviews descriptions of changes to database design to understand how changes to be made affect physical database Coordinates database development and security systems required.
· Responsible for data integrity, backup systems, and database security.
· Maintain the ETL and BI Tools to support the enterprise information systems.
20%
4. Resource Management
· Coordinate the work efforts, scheduling and prioritization for cross-team resources.
· Effectively transition senior level knowledge to other members of the team to help grow the organization as a whole.
· Train and mentor other team members in team standards, processes and methodologies.
· Support the professional development of other team members.
· Effectively delegate tasks to other team members to challenge individuals appropriately.
10%
5. Additional Responsibilities
· Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA), Project Management Life Cycle (PMLC) and Software Delivery Life Cycle (SDLC).
· Other responsibilities and accountabilities may be assigned based on business and organization needs.
Varied
TRAVEL EXPECTATIONS
Regular travel requirements (10% - 15%)
MANAGEMENT RESPONSIBILITY
Manage relationships with applications teams to collaborate & triage technical issues and optimization. Qualifications
MINIMUM QUALIFICATIONS
Education/Certification
A Four-year college Degree is preferable with applicable work experienceExperience
6+ years hands on experience implementing and maintaining MSSQL clusters.3 years hands on experience implementing and supporting SQL Always on
ESSENTIAL KNOWLEDGE, SKILLS AND ABILITIES
Refer to separate handout for Competency definitions (B/basic; P/proficient; E/expert):
Technical
Expert
· Database HA Architecture
· SQL Always On
· SQL Profiler
· MSSQL Performance
· SQL Query analysis
· ETL tools knowledge
· Database administration (design, installation & troubleshooting)
·
Proficient
· High Availability
· Database policy & procedure development
· Infrastructure Technology
· Code Management
· Data Transport
· Enterprise Data Modeling
· General Office Applications
· Information Security
Basic
· Client/Server Systems
· Business Continuity
· Remote Assistance Tools
· SOA Strategy
· User Interface Design
· Microsoft Project
Business
Expert
· Innovative Solution Development
· Benefits of Information Technology
Proficient
· Business Acumen
· Business Alignment
· ITIL
· Project Management Methodology (PMM)
· Requirements Definition
· Risk Management
· Systems Delivery Life Cycle (SDLC)
· Technical Writing
· Test Plans
Basic
· Quality Assurance & Controls
· Release Management
· Service Level Management
· Strategic Sourcing
·
Options Apply for this job onlineApplyShareEmail this job to a friendRefer Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Share on your newsfeed Application FAQsSoftware Powered by iCIMS
www.icims.com