Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

SQL DBA

Expired Job

Millennium Consulting Boston , MA 02118

Posted 2 months ago

SQL DBA

W2 only. No C2C or Sponsorship available.

Description:
10 Months+.
In this role, the SQL DBA will proactively identify, develop and drive DataMart strategies. The selected candidate will be responsible for understanding the clients data management goals and needs, and how these relate to the existing and evolving DataMart.

Responsibilities:

Ensure compliance with IT policies and procedures
Perform validation checks
Apply industry best practices and concepts to facilitate the completion of all project deliverables
Evaluate, design, and manage database systems in a mainframe, cloud, or client/server environment
Work with users to analyze requirements and define specifications for database access, structure, format, documentation, security, back-up and recovery
Troubleshoot and resolve database blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, Data issues, etc.
Maintain database dictionaries and coordinate the installation of new and revised database systems

Skills & Experience
Bachelors degree in related field, or equivalent work experience
At least 8 years of experience in a Database Administrator role
At least 8 years of professional experience doing Microsoft SQL Server (2008, 2012 or greater) database management & database administration
At least 5 years of experience with T-SQL and PowerShell Scripts, ETL is required
In-depth knowledge of relational database systems, relational database design, capacity planning, security, and other distributed data issues
Experience working with SDLC and technical requirements/specifications development and management
Experience with solution assessment and validation
Working knowledge of triggers, stored procedures, and referential integrity
Report production and enhancement
Manage all upgrades and migration activities
Create and maintain written procedure manuals
Ability to manage all database maintenance plan activities, such as backups, indexing, integrity and consistency checks, etc.
Understanding of project management and the software development lifecycle
Experience working in a PMO environment
Experience working with software vendors
Familiarity with Cognos

For over two decades, Millennium Consulting has been a leader in professional staffing. Today, Millennium caters to a diversified portfolio of market-leading customers.

Since its establishment, Millennium has relentlessly focused on unwavering integrity while perfecting the recruitment of subject matter experts for complex, mission critical projects. Our approach remains unchanged: Sweeping analysis of our clients staffing initiatives and organizational culture, combined with a personal approach to long-term relationship building to identify the most impactful talent.

Skills:
SQL, DataMart, T/SQL, PowerShell Scripts, ETL, relational database systems, relational database design, capacity planning, security, SDLC, triggers, stored procedures, referential integrity, upgrades
Contract
10+ months



See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
SQL Database Administrator

Liberty Mutual Holding Company Inc.

Posted 5 days ago

VIEW JOBS 11/11/2018 12:00:00 AM 2019-02-09T00:00 We deliver our customers peace of mind every day by helping them protect what they value most. Our passion for placing the customer at the center of everything we do is driving a transformational shift at Liberty Mutual. Operating as a tech startup within a Fortune 100 company, we are leading a digital disruption that will redefine how people experience insurance. Job introduction: Liberty Mutual Investments (LMI) is looking to hire SQL Database Administrator with Systems administration / SharePoint experience. This candidate will receive general supervision and is competent to work in most phases of database management. Provides database management and support including: Database design; Performance tuning; Backup and recovery; Security; Disaster Recovery; Capacity management. Consults on moderately complex technical issues and contributes to architectural decisions. May act as team leader on moderately complex projects. Assists in training less experienced DBAs. About the job: * Designs, tests, implements, maintains and controls the organization's production and non-production databases. * Collaborates on development of moderately complex technical and security standards with more experienced DBAs and technical resources. * Provides on-call support for production environments. * Provides 24/7 support for various activities including: Database maintenance; Application releases; Disaster recovery; Database upgrades and patching. * Provides consultation to application developers in SQL Coding and tuning, coding and deployment of stored procedures. * Performs related tasks as requested or assigned. Desired skills: * Minimum 6+ years of experience working with MSSQL server in a Windows Server environment required. * Minimum 4+ years of experience with Windows Server Administration / SharePoint Administration required. * Experience in MSSQL Server 2008R2-2016 and Azure SQL DB administration. * Self-starter with a strong understanding of SQL native backups, HA/DR, BCP * Expert in SSRS/SSIS configuration, deployment and able to create DB maintenance packages. * Windows Server 2012/2016 administration, PowerShell or other Scripting. * Exposure to VMware architecture, Citrix and SharePoint Administration. * Able to create SharePoint workflow and functional webpages. * Ninja level indexing, query writing, and tuning skills and a keen eye for automation. * The ability to communicate with non-technical teams and other business stakeholders. * Adept at finding security vulnerabilities and Audit-related risks. * Experienced in enterprise change tracking tools such as remedy, misssuport, ITSM * Able to derive data from SQL server with Excel/PowerBI and create Pivot Tables/Dashboards. * Excellent communicator with a knack of sharing knowledge and a love for technology. * A well-rounded understanding of modern architecture and development practices (DEVOPS/LEAN/AGILE). * Eager to work in an agile environment with basic knowledge of the agile process. * Work allocation: 60% DBA 40% (System administration or SharePoint Administration). Preferred skills: * Strong experience with SharePoint Administration and Workflow. * Exposure to DevOps, CI/CD. * On-premise to cloud migration experience (Azure preferred). * Experience with Azure Availability Groups and Geo-Replication or AWS equivalent. * Idera and Redgate suite of tools for DB administration. * Expert in scripting, python/PowerShell. * Exposure to data analytics (KPI, Metrics, etc.). * Exposure to scheduling platforms such as Active Batch or Tidal. * Exposure to PowerBI gateway and setup of PowerBI on-prem/ cloud. * Linux Administration is a huge plus. * Exposure to BCP. * Certifications in AWS/AZURE/MCSE/MCSA etc. We take care of our employees… We strongly believe that a great job should keep you happy both at work—and in life. That's why we offer: * Workplace Flexibility * Wellness Perks * Collaborative workspaces * Sit/stand desks * Career development, programs and classes * Diversity & Inclusion programs * Commuter Benefits * Adoption Assistance * College Savings Plan * Education reimbursement * Hackathon Events Liberty Mutual was named as a '2016 Great Place to Work' by Great Place to Work US. For more info about our benefits - Liberty Mutual Holding Company Inc. Boston MA

SQL DBA

Expired Job

Millennium Consulting