| : Database Developer|| New York, NY- Hybrid 2-3 days at York, New York, USA |
| Email: [email protected] |
| From: charu sharma, tek inspirations [email protected] Reply to: [email protected] Database Developer Interview: Video Interviews (2-3 rounds) Duration : 1 year with likely extension Location: New York, NY (Hybrid 2-3 days onsite) Other: Candidate must be presented with 3 references Please make sure to submit a candidate who can do technical screening, and has strong communication skills. Need profile with local dl and genuine visa only Required Skills Experience writing SQL Server Integration Services (SSIS) packages for ETL. Experience in data modeling, database design and well versed with DBMS best practices. Experience optimizing and tuning queries. Experience with SQL Server Reporting Services (SSRS) and Power BI. Experience with Informatica is a plus. Ability to see tasks through to completion without significant guidance. Strong issue resolution and investigation skills. Ability to articulate and document the steps taken to resolve an issue. Strong oral and written communication skills and the ability to clearly articulate to all project members and stakeholders. Responsibilities Identify/resolve/prioritize mission critical production issues. Provide technical documentation as needed. Prepare data migration plans including migration risk, milestones, and quality details. Develop and maintain technical documentation such as design documents, specifications, software/stored proc/DB Jobs documents and instructions. Develop scripts and solutions to automate data aging process to move data that meets the aging criteria out of production. Perform data cleanup by performing data merges, deactivation/deletion of duplicate records using logic for exact matches as well as high probability fuzzy matches. Be creative in providing new ideas and potential technical solutions including reviewing new features as they are planned for release. Have thorough understanding and experience of development, deployment, and maintenance of SSIS packages. Have thorough understanding and experience of development, deployment, and maintenance of reports in SSRS. Design advanced SQL queries, stored procedures, triggers, and scripts. Create SQL Server databases and database components utilized TLC applications. Collaborate with applications developers and other key team members (Business Leads, Vendors, and Stakeholders) on data modeling and ER diagrams. Manage database performance, capacity, replication, backup, and security. Develop, implement, and maintain data backup strategy and data retention policies. Perform database migrations from unsupported OS/database servers to supported versions including cloud-based solutions. Assist business analysts and end-users with reporting needs. Develop reports, views, charts, and dashboards to assist program staff with monitoring the outcomes of Agency initiatives. Work with external entities to facilitate secure data transfers. Have exceptional communication skills, including effectively communicating with and interpreting between technical and non-technical team members. Warm Regards.. Charu Sharma IT Technical Recruiter TEK Inspirations LLC | 13573 Tabasco Cat Trail, Frisco, TX 75035 Email: [email protected] Disclaimer : If you are not interested in receiving our e-mails then please reply with a " REMOVE " in the subject line to [email protected] . And mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience Keywords: business intelligence database information technology New York Texas : Database Developer|| New York, NY- Hybrid 2-3 days [email protected] |
| [email protected] View all |
| Wed Mar 27 01:31:00 UTC 2024 |