Vacancy expired!
Description: The Technology department supports our global content company through the delivery of a high quality viewing experience, system infrastructure support, and creating innovative ways for our employees to collaborate. Overview & Responsibilities Tech 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. 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: a. CDC b. Always On c. CTE 6) Backups/Recoveries a. Build Automated/streamlined backup/recovery strategies b. Build post prod environment with scheduled refreshes 7) Builds a. Create and maintain automated db builds b. Generate schema diffs c. Manage db versions 8) Authorization 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. Sql Job Creation/Maintenance 10) Collaboration 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 drainsJob Specifications(e.g., years in field, skills, knowledge, systems etc.) Required Preferred • 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 The post Sr. Engineer, Database Administration appeared first on TSR Consulting Services.
- ID: #43768819
-
State: New York
New york city
10019
New york city
USA
- City: New york city
- Salary:
USD
TBD
TBD
- Job type: Permanent
- Showed: 2022-07-02
- Deadline: 2022-08-30
- Category: Et cetera