As the Database Administrator, you will bring your SQL Server experience providing day-to-day support to the IT team creating the next generation of cloud and mobile-based logistics applications. This is a unique opportunity for an individual seeking new challenges and broad database administration responsibility. The successful candidate will be responsible for monitoring, maintenance, reliability, stability, data integrity, security, and operational support of the entire portfolio of databases. You will also have input in the continual assessment, improvement, and optimization of the current database environment.

Responsibilities:
You will work with Senior Database Administrator, IT teams, and third-party service providers to ensure that Microsoft SQL Server database maintenance tasks are completed, including, but not limited to the following:
  • Monitor and maintain database storage resources.
  • Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics.
  • SQL Server installations, upgrades, migrations, and configuration.
  • Install database software service packs and cumulative updates as necessary.
  • Optimize SQL code as necessary.
  • Assist and support the Power BI team in creating reports and performing data analysis for queries.
  • Maintain database documentation as required.
  • Maintain and administer database security access.
  • Perform database backups and restores.
  • Troubleshoot and resolve database connectivity issues.
  • Create/execute DML operations using TSQL queries.
  • Execute and maintain documentation for scripts shared by the application team for deployments.
  • Follow Change Management processes to implement database configuration changes.
  • Follow Problem Management processes to troubleshoot and resolve recurring issues.
  • Proactively monitor and respond to MSSQL database alerts.
  • Provide on-call support ensuring 24 x 7 x 365 uptime.
Qualifications:
  • 2 years experience as a Microsoft SQL Server database administrator in an enterprise-class environment using the latest releases of SQL Server.
  • 2 years experience in Transact SQL, DTS, SSIS package development.
  • Strong understanding of relational database and data warehousing concepts.
  • Experience in Azure environments preferred, but any other Cloud service provider.
  • Knowledge of database maintenance activities, backup, refresh, and recovery.
  • Experience with reviewing and implementing database security features.
  • Experience with database upgrades and migration projects is preferred.
  • Experience with migrating data from SQL Server to Power BI.
  • Some knowledge of relational database tuning and database clusters.
  • Experience with SSIS and SSRS,
  • Decision-making, problem resolution, and creative thinking skills.


About Harvard Partners, LLP, Trusted Advisors to IT:

Harvard Partners is a management consulting firm focused on helping companies more effectively leverage their IT investment. We engage with the C-Suite and Technology Team to help them better understand their IT infrastructure and process in order to align the technology strategy and organization to reach the firm’s strategic business goals.Some of our practices include:• Program/Project Management and "PMO as a Service"• IT Assessments• Business Continuity/Disaster Recovery• Optimized Infrastructure• Concierge Managed Services• Data Center Strategy, Transformation, and Migration• Cloud Management Programs• Security Assessments and Remediation• Staffing, technical & tacticalWorking with the client’s staff, vendors, and consultants, we deliver supportive and collaborative engagements where direct dialog, simplified reporting, productive meetings, and clear responsibility and accountability encourage active participation resulting in consensus-based business outcomes.


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Bay State Bay State |
Yesterday

We have an exciting opportunity for a Database Developer to join our team.Key Responsibilities:Designs, develops, implements, and maintains complex business, accounting, and management information systems.Works on complex assignments.Design databases.

Intrado Intrado |
3 d ago

Job DescriptionFor this opening we will consider candidates from the following locations: ,QC,Canada |Intrado’s Life & Safety group in Montreal is hiring a Database Developer to join our technology team!Intrado’s Life & Safety division is responsible.

NEXGEN TECHNOLOGIES INC. NEXGEN TECHNOLOGIES INC. |
4 d ago

PART-TIME (TEMPORARY) REMOTE POSITIONEssential Duties and Responsibilities include the following. Other duties may be assigned:Work on building, configuring, and deploying SQL databases.Ability to manage multiple Database Servers, including administration,.

Snappyhires Snappyhires |
4 d ago

Both C2C / W2Location- Pittsburgh, PennsylvaniaDuration- 12+ Months.Remote opportunity but Candidate must come to Onsite once in a Quarter.The applicant needs to have 10 years of recent SQL Server DBA experience (including 2 years' experience with SQL.

GEOGRAPHIC SOLUTIONS INC GEOGRAPHIC SOLUTIONS INC |
5 d ago

Description:Job Summary: The hands-on IT Operations Manager is responsible for the day-to-day management of the high-performing Database Administration, Network, and Systems teams. Management of the company's 24/7/365 Software-as-a-Service (SaaS) infrastructure,.

More jobs by this company

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
4 d ago

As the AWS Cloud Architect/ Engineer, you will help with the integration strategy for Cloud services on AWS as a key player on the Mergers & Acquisitions Cloud Infrastructure team.Responsibilities:Assessing current environments for best practices and.

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
6 d ago

The senior software engineer will be responsible for the Calypso derivatives trading platform, encompassing systems configuration, development and integration for Global and Capital Markets financial derivatives across the trading lifecycle including.

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
6 d ago

As the AWS Cloud Architect/ Engineer, you will help with the integration strategy for Cloud services on AWS as a key player on the Mergers & Acquisitions Cloud Infrastructure team.Responsibilities:Assessing current environments for best practices and.

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
8 d ago

As Principal Architect, you will be instrumental in the successful integration of disruptive technologies within the organization. You will provide architectural mentorship and oversight at a Company/Technical Platform level and work cross-functionally.

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
8 d ago

As the Senior UX/UI Developer, you will report to the Director of Design Engineering and work closely with UI/UX research, design thinking, and design teams to transfer ideas into code. Your background in technology and devotion to good design and aesthetics.

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
17 d ago

The Senior SQL Developer will be apart of the Data & Process Modernization team delivering on Data Strategy & Architecture Partnerships, Tactical remediation of existing/aging data assets andStrategic Project Advisory. Responsibilities include:Collaborate.

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
17 d ago

As the UI/Front end developer you’ll have an opportunity to make a significant contribution to translating customer needs and user expectations into interactive web apps. The right candidate for this role will be hands on and technically proficient in.

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
29 d ago

The User Experience (UX) Designer will work on the Digital Banking team to create best in class mobile experiences. The ideal candidate should have an eye for design and possess superior UX/UI skills. This individual should be able to translate user.