The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
Mg255c6mp85phzxfrgb

Database Administrator II

Job Description

Responsible for supporting and administering a large number of database servers (MS SQL and MySQL) both in a Production and Development environment. The fundamental goal is to ensure the production environment is operational and performing optimally 24/7. 



Responsibilities

  • Perform SQL upgrades
  • Ensure production SQL Servers maintain HA/DR in accordance with the company's RPO and RTO
  • Troubleshoot SQL Server outages as they occur, including after-hours and weekends
  • Respond to and resolve critical alerts during and after business hours (when on-call)
  • Install and configure new SQL Servers
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Implementing Proactive measures to improve performance and reliability
  • Perform other duties as assigned


Qualifications

Knowledge, Skills, and Abilities:

  • Excellent verbal and written communication skills
  • Excellent problem solving skills
  • Ability to work effectively in a team environment with associates.
  • Capability of effective planning and priority setting.
  • Demonstrated critical thinking skills
  • On-call troubleshooting experience within a 24/7 production environment
  • Working knowledge of SQL Server 2008 and up
  • Solid knowledge around database concepts, data models, schema design, etc. 
  • Mid-level T-SQL skills. 

Minimum Qualification:

  • 4+ years with Microsoft SQL Server Monitoring and Alerting Management systems; Idera SQLdm preferred.
  • Management or specialized training/certification. Or equivalent work experience.
  • Experience with SQL Server AlwaysOn with windows cluster management and SQL Server Replication.
  • Experience with SQL Server DB mirroring and log shipping.

Preferred Qualification:

  • Bachelor's degree in Computer Science, Information Systems, Business, or equivalent work experience.
  • 4+ years in a large SQL Server environment with SSIS, SSAS and SSRS
  • Experience with non-relational data extracts from ElasticSearch, Mongo DB, Couchbase.
  • Experience with Big Data concepts.
  • Experience in Agile/Scrum methodology preferred.
  • Experience with Tableau or similar data presentation tool.
  • Experience around data analysis, data profiling, and data cleansing techniques. 
  • Data warehouse experience. 

#dipost

Job Requirements

 

Job Snapshot

Location US-TX-Carrollton
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type Other, IT & Technical
Apply

Company Overview

Securus Technologies

Securus Technologies provides leading edge civil and criminal justice technology solutions that improve public safety and modernize the incarceration experience. Thousands of public safety, law enforcement and corrections agencies rely on Securus for secure, simple and powerful technology solutions that are always accessible and easy to use. With hundreds of patents and scores of engineers, technologists, designers and thinkers innovating solutions, the technology here is second to none. Learn More

Contact Information

US-TX-Carrollton
Snapshot
Securus Technologies
Company:
US-TX-Carrollton
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Other, IT & Technical
Store Type:

Job Description

Responsible for supporting and administering a large number of database servers (MS SQL and MySQL) both in a Production and Development environment. The fundamental goal is to ensure the production environment is operational and performing optimally 24/7. 



Responsibilities

  • Perform SQL upgrades
  • Ensure production SQL Servers maintain HA/DR in accordance with the company's RPO and RTO
  • Troubleshoot SQL Server outages as they occur, including after-hours and weekends
  • Respond to and resolve critical alerts during and after business hours (when on-call)
  • Install and configure new SQL Servers
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Implementing Proactive measures to improve performance and reliability
  • Perform other duties as assigned


Qualifications

Knowledge, Skills, and Abilities:

  • Excellent verbal and written communication skills
  • Excellent problem solving skills
  • Ability to work effectively in a team environment with associates.
  • Capability of effective planning and priority setting.
  • Demonstrated critical thinking skills
  • On-call troubleshooting experience within a 24/7 production environment
  • Working knowledge of SQL Server 2008 and up
  • Solid knowledge around database concepts, data models, schema design, etc. 
  • Mid-level T-SQL skills. 

Minimum Qualification:

  • 4+ years with Microsoft SQL Server Monitoring and Alerting Management systems; Idera SQLdm preferred.
  • Management or specialized training/certification. Or equivalent work experience.
  • Experience with SQL Server AlwaysOn with windows cluster management and SQL Server Replication.
  • Experience with SQL Server DB mirroring and log shipping.

Preferred Qualification:

  • Bachelor's degree in Computer Science, Information Systems, Business, or equivalent work experience.
  • 4+ years in a large SQL Server environment with SSIS, SSAS and SSRS
  • Experience with non-relational data extracts from ElasticSearch, Mongo DB, Couchbase.
  • Experience with Big Data concepts.
  • Experience in Agile/Scrum methodology preferred.
  • Experience with Tableau or similar data presentation tool.
  • Experience around data analysis, data profiling, and data cleansing techniques. 
  • Data warehouse experience. 

#dipost

Job Requirements

 
M4754570lxfxn3g1hqn
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Database Administrator II Apply now