What are the responsibilities and job description for the IT Database Administrator position at the Chickasaw Nation?
We are currently looking for a Full Time IT Database Administrator to join our IT Enterprise Applications Database Administration Team team located at the Abbott Miller Bldg working .
Summary :
The Database Administrator's role is to monitor, maintain, and performance tune production and non-production databases while ensuring high levels of data availability. This individual is also responsible for implementing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
Responsibilities :
- Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers
- Utilize scripting language such as PowerShell automate maintenance tasks
- Utilize backup utility system and Native SQL Server to monitor Database backups
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
- Respond to and resolve database access and performance issues
- Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements
- Measure performance against performance metrics and Service Level Agreements
- Monitor, optimize, and allocate physical data storage for database systems
- Plan and coordinate data migrations between systems
- Participates in the change control process for all planned or unplanned applications and technical activities
- Perform database transaction and security audits
- Perform database transaction and security audits
- Monitor ETL and database maintenance tasks
- Develop routines for end users to facilitate best practices database use
- Rotate on-call duties with the other Database Administrators
- Works closely with the Business Insights and Solutions Data Warehousing team
- Identify, document and ensure the resolution of data quality issues, such as uniqueness, integrity, accuracy, consistency, and completeness, in a cost-effective and timely manner
- Work collaboratively with cross functional teams to identify causes of poor data quality, implement solutions, document, and communicate findings to all relevant stakeholders
- Work with Infrastructure and Operations to monitor, optimize, and allocate physical data storage for database systems
- Work with application development staff to coordinate the creation and management of data queries
- Participate in multidiscipline development teams to create ad-hoc and full life-cycle reports for applications created by the Application Development
- Provides first class customer service - courteous and helpful to all internal and external customer types
- Answers questions in a courteous and professional manner
- Partners with internal and external services as needed to ensure appropriate referral is made
- Greets and engages with a smile
- Determines needs, seeks positive experience and outcomes
- Completes all training and development requirements and participates in continuing education opportunities
- Works in a collaborative and supportive manner to support the productivity and safety of the work area, team members and customers of all types
- Maintains general upkeep of work area and maintains a safe environment
- Maintains and promotes professionalism
- Punctual and consistent in meeting start time, work schedule, attendance and other assigned work time metrics
- Adheres to Chickasaw Nation dress code standards
- Maintains knowledge of and follows all laws, rules, regulations, policies and SOPs for assigned area, e.g. MICS, TICS, hospital standards, health codes, food sanitation, accounting principles, etc.
- Performs all other duties as assigned
- Experience with patching via Microsoft Endpoint Configuration Manager (MECM) Application
- Utilize scripting language such as PowerShell to automate maintenance tasks
- Utilize scripting language such as PowerShell to monitor SQL Server Environments health
Competencies : Essential :
Skills : Experience :
Nonessential :
Education : Essential :
Nonessential :
Nonessential :
Credentials : Essential :
Nonessential :
Working Conditions : Essential :
Nonessential :
