Database Engineer ( - Tanisha Systems

Job Role: Database Engineer (2)
Location: Alpharetta and Client, GA Onsite Role
Long Term Project


Position Overview: The Database Engineer for Digital Project Implementation plays a crucial role in the success of digital projects by managing the databases that underpin them. This role involves designing robust, scalable, and high-performance database solutions, integrating them with various digital platforms, and ensuring data integrity and security throughout the project lifecycle. The ideal candidate will have a strong background in database architecture, data modeling, and hands-on experience with a range of database technologies.

Qualifications:

• 4 - 6+ * technical expertise in database and ETL development with Microsoft SQL Server technologies primarily T-SQL and SSIS.
• Extensive development experience in analysis, modelling, and design of database solutions.
• Integration Services, ETL and BI tools
• Possess strong database fundamentals and experience in writing Unit test cases and test scenarios
• Technical understanding of network, PC, and platform operating systems, including Microsoft Windows Server 2008 through current version.
• Application development understanding of Microsoft .NET technologies primarily Powershell scripting, ASP.NET and C#.
• Technical understanding of the different phases of the Software Development Life Cycle (SDLC) including waterfall and agile methodologies.
• Understanding and technical knowledge of cloud-based technologies.
• Have a grasp of SQL Server High Availability Solutions including Always On, Database Mirroring and Log Shipping concepts.
• Able to effectively communicate verbally and in writing; in large meeting settings and when presenting to large groups; in both technical and non-technical arenas.
• Able to understand and convey technical issues to non-technical associates, and vice-versa.
• Able to develop and maintain effective working relationships across enterprise level lines.
• Able to identify issues warranting escalation.

Key Responsibilities:
1. Database Design & Architecture:

• Design and implement database solutions to support digital project requirements.
• Create data models, schemas, and entity-relationship diagrams to represent data structures.
• Ensure database designs meet performance, scalability, and security requirements.

2. Database Development & Optimization:

• Perform extensive analysis of database entities, relationships and attributes.
• Design and develop ETL (Extract, Transform and Load) processes using Transact-SQL (T-SQL) and Microsoft SQL Server Integration Services (SSIS).
• Optimize ETL processes and T-SQL code performance using Microsoft SQL Server best practices and query/index/table performance tuning.
• Participate in both data design and data processing sessions for assigned projects and teams.
• Create migration/conversion designs that meet the project's business, system and data requirements.
• Create written data migration/conversion plans and data file/data model specifications that meet the project's business, system and data requirements.
• Reverse engineer existing migration/conversion processes and data models including designing and utilizing Microsoft SQL Server Profiler traces.
• Research and review data for presentation, accuracy and compliance within the business/system needs.
• Review with team members/client and other database engineers the content, accuracy and completeness of data models, file specifications and migration/conversion processes.
• Communicate and collaborate with client management and client data specialists in the design and delivery of data migration/conversion processes.
• Respond to data design and/or data processing problems and find solutions in a timely manner.
• Identify appropriate resources and work with them to research and resolve any open data-related issues.
• Mentor staff by reviewing deliverables and offering team assistance whenever needed.
• Possesses a deep knowledge of both the product and the technology; use both to design/architect business solutions.

3. Data Integration & Migration:

• Support data integration between different systems and platforms involved in digital projects.
• Plan and execute data migrations, ensuring data integrity and minimal downtime.
• Collaborate with software engineers to integrate databases with applications.

4. Security & Compliance:

• Support in database security measures, including access controls, encryption, and auditing.
• Ensure compliance with data protection regulations and company policies.
• Conduct regular security assessments and address vulnerabilities promptly.

5. Database Administration & Maintenance:

• Perform routine database maintenance tasks, such as backups, restores, and updates.
• Monitor database health, including disk usage, memory, and CPU utilization.
• Automate repetitive tasks and develop scripts for database management.

6. Collaboration & Support:

• Work closely with project managers, software engineers, and other stakeholders to understand database requirements and constraints.
• Provide technical support and guidance during project implementation and post-launch phases.
• Participate in code reviews, design discussions, and project planning sessions.

7. Documentation & Reporting:

• Maintain comprehensive documentation for database designs, configurations, and processes.
• Prepare reports on database performance, capacity planning, and future growth projections.
• Document best practices and lessons learned from each project.

Submission Format:

• Need updated Resume, * copy, photo id, i94 and travel history for * independent candidate with below details.

Thanks & Regards

Kumar Amar Kant Sr. Account Manager, Tanisha Systems Inc Phone : 408-620-5751 (Direct) Office: (732) 944-0302 Email: amar@tanishasystems.com www.tanishasystems.com Address:99 Wood Ave South Suite # 308,Iselin, NJ 08830