HCL Global System - Farmington Hills, MI

posted about 1 month ago

Full-time - Entry Level
Farmington Hills, MI
Professional, Scientific, and Technical Services

About the position

The SQL Database Administrator (DBA) position involves managing and supporting SQL Server environments across various versions, including SQL 2000, 2005, 2008, 2012, 2014, and 2016. The role requires installation and configuration of SQL Server, along with providing 24/7 support and on-call assistance for migration and monthly rotations. The DBA will be responsible for SQL deployments, application code releases, and conducting code reviews weekly to ensure smooth operations. Performance tuning and optimization (PTO) are critical aspects of the role, utilizing native monitoring and troubleshooting tools to enhance database performance. In addition to performance tuning, the DBA will handle backups, restores, and recovery models, ensuring data integrity and availability. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server is essential. The role also requires experience with Windows Server, including Active Directory, and familiarity with IIS servers. The DBA will be tasked with upgrading SQL Server software, applying service packs and patches, and managing VMware servers. Excellent production support is expected, along with the ability to contact Microsoft for technical support when necessary. Data migration from various sources such as Excel, flat files, and Oracle to MS SQL Server will be performed using tools like SSIS, BCP, and DTS utility. The DBA will also be responsible for database monitoring, administration, upgrades, and disaster recovery planning and testing. This includes maintaining multiple environments (development, testing, and production), patching, troubleshooting, and managing user access and security configurations. The DBA will collaborate with remote DBA services and cross-functional IS teams to ensure database stability and performance, while also developing expert knowledge of applications to provide high levels of user support. The role may require participation in production database support on weekends, and the DBA will be involved in long-range planning for new projects and facilities, advising on database procedures and methods.

Responsibilities

  • Installation and configuration of SQL Server across various versions.
  • Provide 24/7 support and on-call assistance for migration and monthly rotations.
  • Manage SQL deployments and application code releases, including weekly code reviews.
  • Conduct performance tuning and optimization using native monitoring tools.
  • Handle backups, restores, and recovery models for SQL Server.
  • Implement High Availability (HA) and Disaster Recovery (DR) solutions.
  • Work with Windows Server and Active Directory.
  • Upgrade SQL Server software and apply service packs and patches.
  • Manage VMware servers and provide excellent production support.
  • Migrate data from Excel, flat files, and Oracle to MS SQL Server using SSIS, BCP, and DTS utility.
  • Monitor and administer databases, including upgrades and disaster recovery planning.
  • Maintain multiple environments (development, testing, production) and perform patching and troubleshooting.
  • Manage user access and security configurations on SQL Servers.
  • Collaborate with remote DBA services and cross-functional IS teams for database management.
  • Develop expert knowledge of applications for user support.
  • Participate in long-range planning for new projects and facilities.

Requirements

  • Bachelor's degree in Computer Science, Computer Engineering, or a related field (equivalent foreign degree accepted).
  • One year of experience as a Software Developer, Systems Analyst, Programmer, or in a related occupation.
  • Experience with SQL Server, WebServices, LINQ, WCF, .NET Framework, and C#.

Nice-to-haves

  • Experience with SQL Server Reporting Services (SSRS).
  • Experience with SQL Server Integration Services (SSIS).
  • Familiarity with Data Transformation Services (DTS).
  • Knowledge of SQL Server Management Studio (SSMS) and SQL Profiler.

Benefits

  • Referral bonus through employee referral program.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service