Lead SQL Server Database Administrator

Cambium Assessment
Washington, DC
Feb 21, 2021
Feb 24, 2021
Full Time
We are Cambium Assessment, a Cambium Learning Group company. As the leader in online testing for K-12 state education standards, Cambium Assessment delivers secure, reliable, and scalable assessment solutions that improve student performance while supporting state education accountability. Through proven technology, research-backed psychometrics, and advanced machine learning, our solutions help reduce test time for students while improving educational outcomes. We re looking for smart, creative, and enthusiastic professionals to join our innovative team of software engineers, designers, project managers and software specialists. Job Overview The SQL Server Database Administrator is responsible for the installation and maintenance of SQL Server databases to include implementation of new data schema, fields, or data values; backup and restore of databases; monitoring and troubleshooting database issues; and configuring and testing new database features for new releases. Subject Matter Expert (SME) and responsible for providing leadership in Database Administration to all cross functions in the department. Job Responsibilities * Maintain database support documentation * Install and upgrade software and hardware as required to support applications * Manage system storage and capacity planning * Provide end user database support * Monitor database system performance and suggest optimizations as needed * Manage and audit user access to DEV/TEST and PROD databases * Assist in support for resolving system malfunctions * Purchase of new equipment as required * Integrate new equipment, database software, and system software as it is purchased * Provide low-level support to engineering team * Work with Architects and lead developers to come up with optimal database design * Support development staff by tuning SQL queries for maximum performance Job Requirements * Bachelor s degree in relevant discipline; Master s degree preferred * 10+ years of experience with Microsoft SQL Server database administration in a distributed production environment (reporting experience a plus) * 2+ years of production DBA experience including development, test and production database environments * General understanding of database theory, and database design * Experience with Microsoft environment and tools, such as Enterprise Manager, Query Analyzer, and Profiler * Advanced knowledge of SQL language, including ability to write and deploy effective triggers, stored procedures and user defined functions * Ability to perform SQL query optimization. Must know query optimization tools, query plan analysis, techniques for finding inefficient queries. Experience with DTS Packages, jobs, query planning and optimization tools * General understanding of storage technologies (Disk storage, SAN, NAS, SSD, RAID/Striping) and networking (Ethernet, switching, IP, and routing) * Proven ability to work with large (20 GB+ in size) databases: includes knowledge of partitioned data storage, techniques for optimal loading of large data sets, and how large data volume affects replication in SQL Server environment * Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation. Ability to analyze disk space requirements and hardware utilization, automate error notification * Experience with database auditing techniques Preferred Qualifications * Certification in SQL Server 2008+ * SQL Server 2008+ experience on Windows 2008R2+ operating system * Experience with tools such as ERWIN or Embarcadero Why Work With Us? When you work with Cambium Assessment, you ll be helping to design and build inspiring solutions that make a real impact on the online testing industry, as well as the educators and students we support. * Our systems are infinitely scalable and mission critical serving close to 1 million students simultaneously and over 60 million annually! * Our machine scoring methods are driven by artificial intelligence allowing computers to perform such complex operations as grading essays with more accuracy than humans. * Our processes use intensive algorithmic computing allowing a customized experience for each student as the exam adapts real-time based upon answers given. We currently serve more than 1/3 of US students with numerous patents and industry-standard certifications. In the 2018 2019 school year, we delivered more than 60 million tests to 860,000 simultaneous testers with an average 1/10 second response time. We have the most advanced features of any online testing system, and we continue to push boundaries for student performance measurement. Our ground breaking work includes: * Advanced computer-adaptive algorithms * Mobile support of user interfaces * Learning management systems with social media features * Universally accessible user interfaces * Machine scorable items To learn more about our organization and the exciting work we do, visit www.cambiumassessment.com An Equal Opportunity Employer We are dedicated to fostering a culture that celebrates unique backgrounds, ideas, and experiences. All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, religion, sex, gender, gender identity/expression, sexual orientation, national origin, protected veteran status, or disability.