• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 20th Sep 2023

The Database Administrator will be assigned to work with one or more development project teams. In this role they will be expected to:

·        The System Engineer will be responsible for building, supporting and managing end-to-end solutions within Amazon AWS and Azure Cloud environments.

·        Support SCRUM teams in an Agile development environment.

·        Working with the Solutions Designer, Development Architect and third parties as appropriate, the engineer will be responsible for ensuring that a technical design document describing the technical architecture for the program/project is produced.

·        Understand the business and application requirements and translate into a database design.

·        Ensure that all technology selected for the program conforms to the organizations technical long-term strategy.

·        Be responsible for the availability, stability, recoverability and performance of the database environment by ensuring all systems are monitored, patched, and operating optimally. 

·        Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.

·        Develop and deliver extensible/sustainable/quality database solutions based on defined business needs.

·        Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.

·        Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts.

·        Monitor and troubleshoot SQL jobs using available tools such as SQL Profiler, Quest Spotlight, review logs and triage issues.

·        Participate in the resolution of production data issues.

·        Perform code reviews, providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate.

·        Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.

·        Monitor business data stored in production databases, ensuring integrity of the data is maintained.

·        Responsible for developing, maintaining and deploying SSIS packages.

·        Participate in release of all stored procedure projects; including release documentation.

·        Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate.

·        Proactively identify and act on opportunities to improve database systems and processes.

·        Contribute to standards documentation for database coding practices.

·        Prioritize multiple tasks so that aggressive deadlines are met.

·        Provide ongoing suggestions for improvement and innovation within the department.

·        Exhibit sound, methodical engineering judgment, and effectively manage trade-offs in a business environment.

·        Familiar with one or more of the below or other programming languages : VBScript, JavaScript, VB, Java, .NET,PERL

·        Maintain and exhibit knowledge of AWS RDS, Azure SQL and NOSQL database

·        Provide after-hours support as required to address system outages and perform system updates/upgrades/modifications.

·        Identify new processes or modify existing processes to improve efficiencies in the support and monitoring of the department’s production applications.

·        Perform other duties as required.

 

REQUIREMENTS:

 

·        B.S. Degree in Information Technology, Computer Science or a related discipline is preferred.

·        MCSE/Azure Certification preferred.

·        5-8 years of experience in database development and support in MS SQL Server environment.

·        3+ years working experience in deploying physical and cloud instances of SQL Server. (Azure preferred)

·        2+ year of working with PostgreSQL.

·        Working Knowledge of Databricks administration and Datalake, is a plus. (Azure Preferred)

·        Working knowledge noSQL database technology. (Mongo, Cosmos, Others)

·        3+ years of experience in scripting language like Powershell, VB Script, Python, or similar.

·        Strong understanding of Security guidelines in Cloud environment.

·        Open to work on Infrastructure projects and assist on Environment buildouts from Database and Data Analytics perspective.

·        Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking issues, replication/log shipping issues, network/connectivity issues, security issues, etc.

·        Experience in Performance Tuning, Query Optimization using SQL Monitor, New Relic, and other related tools

·        Ability to detect and troubleshoot SQL Server related hardware resource contention such as CPU, memory, disk IO, etc.

·        Solid acquaintance with windows server, security models, and storage components such as SAN.

·        Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

·        Advanced experience with TSQL language and stored procedures, transactional replication, multi node clustering, mirroring, etc.

·        Knowledge of Data Warehousing and Column store databases.

·        A broad understanding of enterprise-class technologies

·        Extensive knowledge and experience with large scale client facing online systems

·        Extensive knowledge and experience with Amazon AWS technologies

·        Extensive knowledge and experience with Windows based technologies

·        Ability to communicate and to interact effectively with co-workers and customers is required.

·        Ability to work and adapt in a dynamic environment and recognize priority issues, escalating accordingly

·        Experience with creating standards and documentation

·        Ability to work both independently or as part of a project group, with time constraints

·        Strong customer service oriented; organizational and communication skills, positive and can-do attitude

·        A technical troubleshooting and prioritization skills test will be part of the interview process.