Database Administrator (Remote)

1245 California Ave, Brockville, ON K6V 7N5, Canada ● Virtual Req #1042
Friday, September 23, 2022
Job Title: Database Administrator(Remote)
Department: Information Technology
Reports to: Director, IT Support Services  
FLSA Status: Exempt 

Company Information: DISA Global Solutions is an industry-leading safety and compliance solutions provider with customers across the U.S. and Canada since 1986 and more than 800 team members across 30 locations. When you join the DISA family, you join an industry leader that more than 27% of fortune 500 companies use. With a rich history of IT innovation, we have more than 40,000 customers and complete more than 6 million orders each year. 

DISA is proud to be a 2022 “Top Workplaces” award winner. We offer competitive pay, a robust benefits package, and an exciting place to work. We have a collaborative and team-oriented culture with numerous opportunities for career advancement. We host monthly appreciation events, and our internal learning and development team provides the resources for employees to engage in continuing education and training.

Position Summary: The Database Administrator ensures the databases (MSSQL, MySQL) and underlying systems, are secure, perform efficiently and are highly available. They also provide second and third line technical support to local and remote staff and will work closing with other IT teams such as DEVOPS, Development Scrum Teams, and Infrastructure.  Responsible for managing, monitoring, and maintaining the database(s). Making requested changes, updates and modifications to database structure and data. Ensuring database security, integrity, stability, and system availability. Maintaining database backup and recovery infrastructure.

Responsibilities:
 • Manage all database instances across development, staging, and production environments, handling installation, configuration, and maintenance
• Make suggestions regarding database design, tuning options, and other potential issues
• Configure database monitoring utilities to avoid false alarms
• Find the most effective solution for increasing performance, including purchasing hardware and making changes to the server configuration or index/query
• Confirm that database server topology, configuration, and maintenance meet SLA goals when designed and executed
• Monitor for deviation in baseline system performance, and advise on and execute improvements to slow running queries
• SQL and Windows patching.  Develop, Implement, and maintain appropriate patching policies and procedures 
• Triage database performance issues – use monitoring tools to identify bottlenecks and leverage knowledge of database performance concepts to resolve in concert with internal and external partners
• Triage data issues – identify root source of problem data and implement measures to correct and prevent
• Develop and execute data migration procedures for moving data between database platforms without service disruption
• Ensure instrumentation of all data access interfaces and work with DevOps to ensure that all interfaces and databases can be monitored and alert under stress
• Acts as Corporate Data Steward and ensures proper data governance and rigor to include accessibility and security compliance, and user authentication and authorization
• Accessibility and security compliance
• User authentication and authorization between multiple systems, servers, and environments
• Integration of multiple data sources and databases into one system
• Creating database schemas that represent and support business processes
 
Qualifications required:
• 5+ years of experience in database administration, information technology, database architecture, or a related field
• MCSE/MCSA, Azure Database Administrator Associate certifications preferred
• Experience with Linux and Windows Server environments
• Understanding of relational and dimensional data modeling
• PowerShell and Unix shell scripting skills
• Familiarity with SSAS, SSIS, SSRS
• Experience developing and maintaining documentation
• Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
• Strong SQL expertise: analytic functions, CTEs, transactions, complex queries
• Proficiency in accessibility and security compliance, user authentication and authorization between multiple systems, servers, and environments
• Storage and server hardware experience a plus
• Develop data strategies that define how the data will be stored, consumed, integrated, and managed by different data entities and IT systems, as well as any applications using or processing the data
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Experience with one of the following toolsets: SQL Server Management Studio, Redgate SQL Toolbelt, SQLYog, AppDynamics.
• Strong familiarity with database performance concepts
• Experience with ServiceNow or other IT ticketing system
• Strong understanding of all phases of the application development lifecycle and project management disciplines.
• Excellent organization, teamwork, problem-solving, and communication (verbal and written) skills.
• Ability to work well with people in all levels of the organization.
 
EDUCATION
• Bachelor’s degree or greater in Computer Science, Computer Engineering or Information Systems
 
EOE/M/F/Vet/Disability 




Other details

  • Job Family Administrator
  • Job Function IT
  • Pay Type Salary
  • Travel Required No
Location on Google Maps
  • 1245 California Ave, Brockville, ON K6V 7N5, Canada
  • Virtual