Database Administrator

Mindlance
Boston, MA
22 May 2024

Vacancy expired!

Job Title: Database Administrator

Location: Remote

Duration: Targeting at least six months for the initial contract term, with the possible option to either a) move into an FTE position after a 6 month-period or b) extend for an additional 6-month term, although the contract term and any extension will be subject to project duration.

Hours/week: 35 hours
  • The client is looking for an experienced database administrator to grow and improve the SQL Server services our department provides to our customers.

Responsibilities
  • Capacity planning - Work with our infrastructure team to analyze SQL Server utilization and plan for future capacity requirements.
  • Software installation and maintenance - Initial installation and configuration of SQL Servers, application of patches, and upgrades as required.
  • Manage data migrations and replication.
  • Database Backup and Recovery - create backup and recovery plans and procedures based on industry best practices.
  • Utilize public and private cloud resources for provisioning servers, database setup, patching, and backups.
  • Analyze and recommend serverless database services like RDS, Azure SQL, Aurora, etc. best suited for the project requirements.
  • Database tuning and performance monitoring - As part of ongoing maintenance, proactively tune and optimize databases to operate at maximum efficiency. This could be configuration changes, indexing the DB, or helping developers and operations teams in tuning the queries to improve performance.
  • Troubleshooting - support production operations in resolving database issues.
  • Security monitoring - Identify and analyze potential weaknesses and recommend/implement best practices to minimize risks. Analyze logs for possible damage in case of a breach.
  • Automate routine processes using T-SQL, PowerShell, and/or other scripting languages.
  • Provide support for critical production systems during and after business hours as needed.
  • Provide support in the administration, backup, integrity, and security of SQL databases.
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Maintain database servers and processes in coordination with other DBAs as needed.
  • Maintains quality service by helping to establish and enforce organization standards
  • Attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state-of-the-art practices, and participating in professional societies.

Qualifications:
  • Minimum 5+ years of experience working with Microsoft SQL database systems required.
  • Microsoft SQL DBA experience with HA\DR features like SQL Failover clustering, AlwaysOn, and log shipping.
  • Experience designing Microsoft SQL database architecture, logical and physical, automation, documentation, installs, shell scripting, T-SQL programming, backup & recovery, monitoring, and database and query tuning.
  • Knowledge of database-related technologies: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SSIS, and SSRS.
  • Knowledge of other database systems (Oracle, MYSQL, PostgreSQL, MongoDB, etc.) is a plus.
  • Azure & AWS experience.
  • Strong technical aptitude with a passion to learn about enterprise IT and IS best practices.
  • 5+ years of relevant business and working experience are required to ensure tasks are completed without supervision.
  • 5+ years of strong experience in a Microsoft Windows environment and the ability to document systems engineering efforts.
  • Experience working with Linux environment.
  • Experience identifying database requirements, and designing proposed systems.
  • Experience designing solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
  • Experience maintaining database performance by calculating optimum values for server configurations, implementing new releases, completing maintenance requirements, and evaluating computer operating systems and hardware products.
  • End-user support experience including training, and problem-solving.
  • Current professional and technical certifications are a plus.
  • Ability to multitask, nimbleness, and highly functional within a team environment.
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veteran
  • ID: #41378090
  • State: Massachusetts Boston 02108 Boston USA
  • City: Boston
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-05-22
  • Deadline: 2022-07-19
  • Category: Software/QA/DBA/etc