Infrastructure Architect

Project Role :Infrastructure Architect




Project Role Description :Lead the definition, design and documentation of technical environments. Deploy solution architectures, conduct analysis of alternative architectures, create architectural standards, define processes to ensure conformance with standards, institute solution-testing criteria, define a solutions cost of ownership, and promote a clear and consistent business vision through technical architectures.


Must have skills :Microsoft SQL Server Database Administration, Cloud Infrastructure



Good to have skills :NA
Minimum



3 year(s) of experience is required



Educational Qualification :BTech


Summary:Azure & On Prem MS SQL Database Administrator will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases.

Install/Configure/Setup/Administer and Maintain production and non- production environments.

Setup High-Availability and Disaster Recovery

Plan and test high availability and disaster recovery

Create Users and assign/manage permissions based on the level of access the user would need.

Resolve database integrity, performance, blocking, connectivity, and replication issues.

Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.

Perform and manage Database backup/recovery/restore and capacity monitoring.

Setup SQL agent jobs, elastic jobs, and runbook automation.

Identify and set up alerts and logging in Azure.

Maintain databases – Statistics, Indexes, fragmentation.

Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)

Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.

Support production deployment activities.

Provide 24x7 support, as necessary.

Conduct Performance tuning and optimization.
Professional & Technical Skills:

Must To Have Skills:Cloud Infrastructure and Microsoft SQL Server Database Administration.

Good To Have Skills:Experience with other cloud platforms such as AWS or Azure.

Strong understanding of DB architecture and design principles.As an Infrastructure Architect, you will be responsible for leading the definition, design, and documentation of technical environments. Your typical day will involve deploying solution architectures, conducting analysis of alternative architectures, creating architectural standards, defining processes to ensure conformance with standards, instituting solution-testing criteria, defining a solution's cost of ownership, and promoting a clear and consistent business vision through technical architectures.
Roles & Responsibilities:

Lead the definition, design, and documentation of technical environments.

Deploy solution architectures and conduct analysis of alternative architectures.

Create architectural standards and define processes to ensure conformance with standards.

Institute solution-testing criteria and define a solution's cost of ownership.

Promote a clear and consistent business vision through technical architectures.
Professional & Technical Skills:

Must To Have Skills:Experience in Cloud Infrastructure.

Must To Have Skills:Proficiency in Microsoft SQL Server Database Administration.

Good To Have Skills:Experience in Infrastructure Architecture.

Good To Have Skills:Knowledge of Cloud Computing.

Good To Have Skills:Knowledge of Virtualization Technologies.
Additional Information:

The candidate should have a minimum of 3 years of experience in Microsoft SQL Server Database Administration.

The ideal candidate will possess a strong educational background in Technology & Information Architectures, along with a proven track record of delivering impactful data-driven solutions.

This position is based at our Gurugram office.


Qualifications

BTech