The American Institutes for Research (AIR) is a leading professional services firm with a growing software engineering and product development team. We design and build things that are inspiring and make a real impact in the online testing industry. We are currently seeking a Senior SQL Server Database Administrator (DBA) for our Washington, D.C. (Georgetown) office. Be part of something innovative and cutting edge. Join our team of more than a hundred software engineers, designers, project managers and software specialists that are smart, creative and excited by what they do. Some of our ground-breaking work includes: advanced computer-adaptive algorithms (only one that's peer-approved in the country) mobile support for the user interfaces learning management systems with social media features user interfaces that are universally accessible to people with or without disabilities innovative, machine-scorable items
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. Additional 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
REQUIRED: 3+ years' experience administering and maintaining replicated Microsoft SQL Server databases 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. 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: Certification in SQL Server 2008+ SQL Server 2008+ experience on Windows 2008R2+ operating system Experience with tools such as ERWIN or Embarcadero
AIR offers an excellent compensation and benefits package, including a fully funded retirement plan, generous paid time off, commuter benefits, and tuition assistance. For more information, please visit our website at www.air.org. To apply, please go to TBD. Candidates must apply online for consideration. EOE.
Candidates only! It is NOT OK for recruiters or others to solicit this company.