Senior Database Administrator - Remote

CentralSquare is a unique enterprise software company whose mission is to build safer, smarter, more connected communities. We serve over 7,500 organizations in North America, from large cities to counties and towns of every size. We provide software for managing public safety (#1 market share) and public administration (#2 market share), enabling first responders to do their jobs as effectively and safely as possible. Learn more by visiting .

What We're About

At CentralSquare, you'll get the opportunity to work in a collaborative environment within a company that builds complex web-based enterprise applications for our Public Servants across North America.

Looking to grow your career? That's great! We believe in growing and cultivating careers here. There is plenty of room for growth for motivated people.

Hard work should be rewarded. We are committed to providing competitive compensation with a great benefits package, including tuition reimbursement, parental leave, paid volunteer hours, and unlimited PTO. Our flexible work environment also enables you to take advantage of an excellent work-life balance whether you are in office or working remotely.

The Role

CentralSquare is seeking a Senior SQL Server database administrator/engineer to join our Cloud team. Ideal candidates must be self-motivated and possess strong analytical and communication skills. The role requires off-hours and weekend availability when on-call (paid). This SR DBA roll will partner with the Jr. Database Administrator in maintaining and providing 24/7 support of the database management systems for CentralSquare's Cloud product offerings based on Microsoft database technologies. This position will be involved in providing support for the Microsoft SQL Server infrastructure which includes programming, installation, and monitoring, tuning and troubleshooting issues for a commercially hosted 3-tier application in a high availability environment. This role will be working with optimizing database performance, database upgrades and/or migrations.

Responsibilities:

• Support the operational environments' database systems across SQL Server,
• Provide input on capacity planning, high availability solutions and upgrade strategies
• Ensure all access controls are followed including, SOC, PCI, CJIS and HIPPA.
• Manage lifecycle support of database systems by applying patches, upgrades, and routine database maintenance in an automated fashion.
• Plan and execute database migrations as needed.
• Monitor and improve performance; diagnose and resolve database-related problems.
• Design and manage backup and recovery processes and continuity of operations plan.

Requirements:

• SQL Server and SRSS required
• 7 years of database administration experience working on complex web-based applications
• AWS RDS and AWS Aurora experience preferred
• Knowledge of the principles and practices of database design, management, and maintenance
• Experience with replication and clustering strategies for high-trafficked systems
• Production experience with performance tuning queries and stored procedures
• Experience with large scale data sets in a high-performance environment
• Familiarity with a database deployment and version management tools
• Desire to work in a collaborative environment across multiple teams
• Automation skills using TSQL, and PowerShell
• Understanding of and experience with Change and Incident Management processes
• Experience supporting large scale databases on AWS or Azure as well as VMware
• Automation knowledge of Docker, Ansible, Jenkins is a plus

Personal Qualities:

• Excellent work ethic, attention to detail, ability to work in a highly collaborative, collegial, multidisciplinary fast paced team environment.
• Excellent analytical skills with the ability to manage multiple priorities and requests.
• Excellent communication and interpersonal skills.
• Ability to work independently and meet requested deadlines promptly.

One more thing: Extended skill sets are welcome and encouraged so don't be afraid to send us your resume even if you are a bit uncertain.

Okay-last thing, promise: Share this with friends; we could have something that suits them too!

CentralSquare Technologies is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.