Millennium Consulting Boston , MA 02118
W2 only. No C2C or Sponsorship available.
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.
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.
SQL, DataMart, T/SQL, PowerShell Scripts, ETL, relational database systems, relational database design, capacity planning, security, SDLC, triggers, stored procedures, referential integrity, upgrades