Ref No.: 17-00076
Location: NYC, New York
Stratacent is all about delivering world class IT solutions that are perfectly aligned to client needs, no matter how complex they may be. We are highly focused on our customers and our primary goal is to exceed expectations with every client who partners with us, with solutions that are innovative, practical and versatile enough to take their business to the next level. We follow the highest standards of professional ethics, delivering quality on time every time. Across every project we strive to deliver reliable, scalable and agile solutions to clients’ technology needs integrating our core values of excellence, commitment, collaboration and creativity. Our offsite development center is located at 101 Hudson Street, Jersey City, NJ a building covering 1.25 million square feet of space in a “Class A” office tower 42 stories high, looming over the Hudson River/NYC Skyline and just 10 minutes from Wall Street in lower Manhattan.
 
Job Title   SQL DBA
Location    NY
 
Job Description:
  • Design, implement and maintain an enterprise data architecture strategy to ensure the success of the enterprise data management and governance program.
  • Communicate the data architecture strategy effectively to all levels within the company, from senior level management to associates and 3rd parties.
  • Provide technical and data leadership to the data operations group and the organization.
  • Work closely with other groups and IT to coordinate current and future plans and activities including coordination and technical assistance to facilitate development projects that involve the computing environment, the coordination of software upgrades, periodic OS and software patching and the installation of new products.
  • Participate in all development projects to ensure the data architecture guidelines are applied.
  • Direct research on potential technology solutions and implementations in support of new initiatives, opportunities, and procurement efforts.
  • Establish and maintain regular written and in‐person communications with the organization’s executives, department heads, and end users regarding pertinent Data activities.
  • Define and execute the enterprise data governance roadmap
  • Understand, monitor and implement solutions to protect the privacy, integrity and availability of all data collected and stored within the data management platforms.
  • Maintain database performance and availability by identifying and resolving production and application development issues.
  • Develop best practices and guidelines for existing or new technologies within responsible area(s).
  • Maintain peak efficiency of all data-related activities.
  • Ensure successful completion of periodic data loads from source systems in and out of the organization into the data warehouse and data management platform
  • Assignment of proper permission levels for all users of the various databases to configure governance.
  • Completes company required training by established deadline.
  • Complies with all Funds’ standards, applicable health and safety rules and regulations, as well as applicable local, state and federal laws.
 Requirements:
  • 3+ years’ experience in information architecture, database administration, data architecture, data modeling, data warehousing, data governance, and ETL techniques.
  • 3+ years’ experience in MS SQL Server database administration
  • Gatekeeper for all Data Governance activities with Support and Development teams in the areas of Change Control, Model Repositories, and Data Profiling/Data Quality activities.
  • Liaison with Business Units, IT and 3rd parties by serving as the point of contact for Business Unit regarding new requests related to data operations.
  • Expertise in OLAP data architecture and modeling, relational database technology, transaction processing, data warehouse design, and tabular model design.
  • Expertise with MS SQL 2008/2012/2016 SSMS/SSIS/SSRS/T‐SQL
  • Expertise with SSIS Data Profiling and Data Quality Services (DQS).
  • Expertise with a modeling tool such as ER-Studio or Erwin.
  • Experience with established and emerging data technologies and concepts
  • Experience in leading data integration and change management
  • Experience with PowerShell (DBA Tools) a plus.
  • Ability to express complex technical concepts effectively, both verbally and in writing.
  • Ability to work well with people from many different disciplines with varying degrees of technical experience.
  • Strong leadership skills.
  • Highly self‐motivated, self‐directed, and attentive to detail.
  • Ability to effectively prioritize and execute tasks in a high‐pressure environment.
 Employee Benefits
  • Premium Health Insurance
  • Premium Vision Plan
  • Premium Dental Plan
  • Short Term Disability Plan
  • Long Term Disability Plan
  • Life Insurance
  • Paid Time Off
  • Continuous Learning Program
Stratacent is an equal opportunity employer. As such, to the extent defined by federal, state, and municipal law, Stratacent will not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, age, sex, national origin, ancestry, handicap, or any other factor protected by law.