Data Specialist Job
Job Description Job Attributes+
New York, NY 10019, US
Contract to Perm
Blackstone Talent Group, an award-winning technology consulting and talent agency is seeking a Data Specialist to join our team at our client’s site in New York, NY.
Our cutting-edge Digital Media client is hiring an application DBA who will be responsible for designing, implementing, and supporting complex database jobs with SSIS orchestration and complex stored procedures, focusing on optimization. Our client utilized many batch processes to synchronize or integrate systems. These processes need expert optimization to reduce processing time, as well as deliver quality results faster. Part of this responsibility will be to design and implement test harnesses to ensure changes to processes yield accurate results faster.
Role Details: Accountabilities / Duties /Key Projects (Essential Functions of the job)
1) Application performance
a. Capture profile traces to identify causes of degraded performance
b. Analyze Indexes balancing storage optimization with query execution
c. Query optimization /Query plan analysis
d. Overall analysis and identification of root cause for degraded performance
2) Best practices/standards during application initiation
a. Understand best practices for automating data and schema deployments
3) Database sizing
a. Ensure proper growth strategy configuration
b. Analyze drive space consumption and project future drive space needs
c. Build & implement data archiving strategies
d. Build & maintain partition strategies
4) Code reviews
a. Analyze and optimize database queries
b. Standardize and review application design: CTE versus cursor, etc.
c. Debug stored procedures
5) Discover, learn, and teach features of SQL server – current rev and future revs, such as:
b. Always On
a. Build Automated/streamlined backup/recovery strategies
b. Build post prod environment with scheduled refreshes
a. Create and maintain automated db. builds
b. Generate schema diffs
c. Manage db. versions
a. Manage streamlined standard authorizations for super users
b. Manage process and compliance for system access
9) Database Architect
a. Model schemas
b. SSIS package creation
c. Sal Job Creation/Maintenance
a. Working closely with development, dba will be informed about new development plans and changes
b. Because the application DBA works consistently on a specific set of applications, he/she will acquire better overall understanding of how each application
works, enabling better partnership with the application developers
c. With a more comprehensive understanding of the application, an application DBA will have a better understanding of how the application impacts the overall business. This knowledge will result in the execution of DBA tasks to better support the organization.
11) Use upgrade wizards to plan and execute SQL server version upgrades
12) Monito the standard SQL perfmon counters, use wait stats and DMV (showing top queries, index suggestion, etc.) to identify cause of performance drains
REQUIRED FOR THIS ROLE:
•5 years of experience writing complex TSQL (Sql Server), specifically stored procedures
•3 years of experience with SSIS
•3 years of experience implementing complex batch processing for large enterprise system, requiring 24/7 support for critical business operations
•3 years of database object optimization experience
Blackstone Talent Group is a division of Blackstone Technology Group, a global IT services and solutions firm that implements technological solutions across commercial industry verticals and the US Federal Government. Blackstone’s global talent augmentation practice was founded in 1998. Blackstone Talent Group has offices in San Francisco, Denver, Houston, Colorado Springs, and Washington, DC. We specialize in providing clients the best talent across a variety of industries and sectors.
EOE of Minorities/Females/Veterans/Disabilities
Who We Are
Founded in 1998, Blackstone Talent Group is one of three divisions of Blackstone Technology Group. The other two divisions are Blackstone Federal, a premier engineering + transformation agency that serves the federal government, and Trellis Energy, the largest transaction management software firm fully dedicated to serving the natural gas industry. Blackstone Technology Group is a privately-held global IT services, solutions and resourcing firm. Headquartered in San Francisco, Blackstone now has more than 300+ employees across five offices nationwide. Blackstone Technology Group’s mission is to help clients adapt to the demands of a digital world, and has garnered an impressive track record of delivering successful results to a client list that includes Fortune 100 businesses and US federal, state and local government.
WHAT WE DO
We provide contract, permanent and managed resource services to our clients. We source for commercial businesses and non-profits, as well as government clients requiring security clearances from public trust through multiple levels of top secret. Some of our skill specialties are IT, IT Operations, Engineering, Accounting and Finance, and Executive Search.
HOW WE DO IT
Our team never stops building connections with talent. And our network of fully-vetted, ready-to-work professionals allows us to provide exceptional speed and accuracy in our resource delivery that is unmatched in the industry. With a relationship-first engagement approach, we most often become a trusted partner with our clients and operate as an extension of their organizations.