Skip to Main Content

Hybrid :: SQL Database Administrator :: Washington, DC

Convextech
Washington, DC
  • Expired: over a month ago. Applications are no longer accepted.
Job Description

Job Title:- SQL Database Administrator

Duration:- Long term contract/Fulltime

Location:- 1155 16th St NW, Washington, DC 20036 (Hybrid Role)

Interview:- Immediate

Client: Kforce/American Chemical Society

Website: American Chemical Society (acs.org)

About: The American Chemical Society is a congressionally chartered independent membership organization which represents professionals at all degree levels and in all fields of the chemical sciences. With more than 150,000 members, ACS is the world's largest scientific society and one of the world's leading sources of authoritative scientific information. A nonprofit organization, ACS is at the forefront of the evolving chemistry enterprise and the premier professional home for chemists, chemical engineers and related professions around the globe. ACS is dynamic and visionary, committed to "Improving people's lives through the transforming power of chemistry." This vision developed and adopted by the ACS Board of Directors after broad consultation with the membership fully complements the ACS Mission statement, which is "to advance the broader chemistry enterprise and its practitioners for the benefit of Earth and its people." Together, these two statements represent our ultimate reason for being and provide a strategic framework for our efforts. ACS publishes numerous scientific journals and databases, convenes major research conferences and provides educational, science policy and career programs in chemistry. We also give more than $22 million every year in grants for research in petroleum and related fields. We also play a leadership role in educating and communicating with public policy makers and the general public about the importance of chemistry in our lives.

Data Platform Services Overview

The Data Platform Services (DPS) team provides high quality data and database related technical guidance and support for the American Chemical Society. The team focuses on excellent customer service while delivering data platforms and database systems support, administration, and maintenance. Through these means DPS aims to advance the mission and vision of the American Chemical Society.

Position Summary

The incumbent in this position, as a member of the Data Platform Services (DPS) team, is responsible for administering and managing databases and database platforms that support the business systems and functions within the ACS data centers. The incumbent reports to the DPS Team Manager and works under his/her managerial direction. The incumbent performs advanced database and database server platform administration and maintenance tasks and provides support to application teams on relevant database tasks. Incumbent is a recognized technical resource for the Systems Administration Team for Database and Data platforms administration and is expected to contribute to the daily resolution of database related requests. This position may lead medium to large sized projects and is expected to have excellent communication and support skills to facilitate partnerships with peers and customers.

Position Accountabilities

  • Provide advanced database and data platforms administration, management, and maintenance to ensure optimal performance of databases.
  • Need to be proficient in managing and providing support on MS SQL Server database platform. Experience standing up and managing AG clusters preferred.
  • While the priority is MS SQL Server, experience managing Oracle database servers and databases on Linux a plus. Experience with Oracle RAC would be nice to have.
  • Experience migrating/administering database workloads in AWS CLOUD preferred
  • Work with application teams and provide database support for ACS applications.
  • Perform database and database server level security and bug fix patching. Assist server teams on OS patching for database related tasks.
  • Perform database platform upgrades. Plan and implement new servers/VMs for new release of database software.
  • Responsible for troubleshooting database level errors, resolving and identifying root cause.
  • Lead projects as assigned by technical manager or team manager.
  • Assist team members in the completion of major projects.
  • Participate in project planning meetings and take a lead role in reviewing technical requirements.
  • Document tasks performed for future reference.
  • Exhibit strong verbal and written communication skills, proactively communicating with customers and framing technical issues so that they can be readily understood.
  • Independently utilize in-house and online resources to research solutions for complex problems.
  • Work with outside vendors to resolve technical issues in a timely manner.
  • Follow Standard Operating Procedures and utilize established support tools.
  • Maintain awareness of standard Washington infrastructure operations procedures and actively research new technology.
  • On-call duties and off-hours work required.

Education/Experience/Technological Knowledge

  • College degree or equivalent experience. Database certification is a plus.
  • Minimum 5 years of experience on MS SQL Server Database platform on Windows OS is necessary. Experience with SQL Server 2019, 2016, 2012 preferred. Deep Hands-on expertise in architecting, installing, and configuring SQL Server stand-alone servers and AG clusters preferred.
  • Experience with database high availability, disaster recovery, database backup management is a plus. As lead DBA, expectations include working and leading major initiatives, planning and building out SQL Server platform with new release upgrades and working within infrastructure and with application teams on major SQL Server release upgrades.
  • Certifications and experience in Cloud technologies a plus.
  • A state-of-the-art awareness in the areas of databases, database servers, email communications, web technologies, software, hardware, system performance measurement, configuration analysis and computer security. Excellent written, oral communication and organizational skills.

If you are interested please answer the below questions:-

  • Describe your experience with installing/configuring SQL Servers and managing databases.
  • What type of tasks/projects have you worked?
  • Number and size of databases. Tiers?
  • Have you worked with availability groups?
  • What has been your exposure with Oracle?
  • Have you managed Oracle databases?
  • Any experience with Oracle RAC?
  • Any experience architecting/administering databases in Public Cloud?
  • Database migration to Cloud, specifically on AWS?
  • If yes, provide short summary of projects/initiatives/tasks you performed?

Thanks and Regards

Rohit Nath

Lead IT Recruiter

Cell: 469-923-6774

Email: rohit.nath@convextech.com

Convextech

Address

Washington, DC
20036 USA

Industry

Technology