Post your Job

$225 for fulltime

$75 for freelance

Sign in  No account? Post your opening first!

Lead SQL Server Database Administrator

Overview:

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

Responsibilities:

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

Qualifications:

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.

How to apply

https://jobs-airdc.icims.com/jobs/8851/lead-sql-server-database-administrator/job

Smashing Jobs

Your new job

Smashing Jobs is your job board that will help you find the right person for your job opening. It is featured at Smashing Magazine — a magazine that has more than 4 million monthly users and is known to be one of the most successful magazines for creative professionals.

Since 2008, we have been helping great companies as well as gifted job seekers to find their way to each other. We are trusted by companies of all sizes, such as Electronic Arts, Amazon, Lonely Planet, Garmin, Tesla Motors, Rockstar Games, MIT Technology Review, Mercedes, Activision, MTV and, last but not least, Nokia.

More Talents Needed?

Use our credit packages to cut your recruiting costs:

5 CreditsOnly $300. 20% discount. You save $75.
10 CreditsOnly $525. 30% discount. You save $225.

You can choose your preferred credit package during the posting process.

Paypal & Credit Cards
Paying is easy. You can pay from your PayPal deposit or simply start straight with your credit card.

There’s also the possibility of invoicing in which the alternative payment options are via bank transfer or check. If you’d like to get your job posting up and running in a minute, we could forward you a coupon code asap and you can pay later. Just contact Lars (lars<dot>andersen<at>smashingmagazine.com).