Senior SQL Server DBA|Architect with Azure | LOCAL TO PENNSYLVANIA
Job details
Job description, work day and responsibilities
Job highlights
Identified by Google from the original job post
Qualifications
Looking for a highly skilled Microsoft SQL Server DBA/Architect/Consultant who can provide both hands-on expertise in managing, optimizing, and scaling SQL Server environments, as well as strategic guidance in assessing current database systems and recommending future-state architectures
The ideal candidate will have deep experience with both on-premises SQL Server environments and Azure cloud-based solutions
Education: Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience)
Experience: 7+ years of experience as an MS SQL Server DBA/Architect/Consultant, with a focus on both on-premises and cloud (Azure) environments
Expertise in Microsoft SQL Server (versions 2012 to 201+) and Azure SQL Database, SQL Managed Instance, Azure Synapse Analytics, and other Azure data services
Strong experience with database performance tuning, optimization, and indexing strategies
Proficiency in instance consolidation strategies and practices to optimize resources and reduce costs
Knowledge of Azure cloud architecture, including PaaS, IaaS, and hybrid solutions
Proficiency in T-SQL, PowerShell scripting, and automation tools
Experience with SQL Server Always On Availability Groups, clustering, log shipping, and other HA/DR strategies
Experience with data warehousing concepts, ETL processes, and tools like SSIS and Azure Data Factory
Excellent communication and presentation skills, with the ability to effectively convey technical information to non-technical stakeholders
Strong problem-solving skills and a proactive approach to identifying and addressing potential issues
Ability to work independently and collaboratively with cross-functional teams
Strong analytical and organizational skills with attention to detail
Certifications such as Microsoft Certified: Azure Database Administrator Associate, Azure Solutions Architect Expert, or equivalent
Experience with other database platforms (e.g., Oracle, MySQL, PostgreSQL) and NoSQL databases (e.g., Cosmos DB, MongoDB)
Familiarity with DevOps practices, CI/CD pipelines, and tools such as Jenkins, Azure DevOps, and Git
Experience with Power BI, SSRS, and other data visualization and reporting tools
Proven Supplier of the Year by Workforce Logiq (2020 and 201+)
Responsibilities
Location: Reading, PA (Hybrid - 3 days onsite in a week is required)
This role will involve working closely with technical teams, business stakeholders, and clients to design, implement, and maintain robust database solutions that meet business needs and support digital transformation initiatives
Database Architecture and Design: Assess existing database environments (as-is state) and provide expert recommendations for designing optimal future-state (to-be) architecture, including cloud migration strategies, scalability, performance, and high availability
Database Administration: Perform hands-on installation, configuration, patching, and upgrading of Microsoft SQL Server databases in both on-premises and Azure environments
Azure Expertise: Design and implement Azure-based data solutions, including Azure SQL Database, SQL Managed Instances, Azure Synapse Analytics, Data Factory, and other Azure data services
Performance Tuning and Optimization: Analyze, troubleshoot, and resolve performance issues at the database and query levels
Recommend and implement indexing strategies, query optimization, and other performance-enhancing techniques
Advisory Role: Act as a trusted advisor to clients and stakeholders by providing insights and recommendations on database best practices, modernization, and digital transformation strategies
Data Security and Compliance: Ensure database systems meet security and compliance requirements, including role-based access control, encryption, auditing, and GDPR or HIPAA regulations
Disaster Recovery and High Availability: Design, implement, and manage disaster recovery (DR) and high availability (HA) solutions, including Always On Availability Groups, replication, and geo-redundancy
Automation and Scripting: Develop and implement scripts and tools for automating routine database administration tasks, deployments, and monitoring
Collaboration: Work closely with development, infrastructure, and DevOps teams to support the application lifecycle, including database development, release management, and continuous integration/continuous deployment (CI/CD) pipelines
Documentation and Reporting: Maintain comprehensive documentation of database architecture, configurations, policies, and procedures
Provide regular reports and insights on system performance, usage, and optimization opportunities
Training and Mentorship: Provide training, mentorship, and knowledge transfer to internal teams and clients to build their capabilities in database management and architecture
Job description
Net2Source Inc. is an award-winning total workforce solutions company recognized by Staffing Industry Analysts for our accelerated growth of 300% in the last 3 years with over 5500+ employees globally, with over 30+ locations in the US and global operations in 32 countries. We believe in providing staffing solutions to address the current talent gap – Right Talent – Right Time – Right Place – Right Price and acting as a Career Coach to our consultants.
Role: Senior SQL Server DBA/Architect
Location: Reading, PA (Hybrid - 3 days onsite in a week is required)
Contract
Looking for a highly skilled Microsoft SQL Server DBA/Architect/Consultant who can provide both hands-on expertise in managing, optimizing, and scaling SQL Server environments, as well as strategic guidance in assessing current database systems and recommending future-state architectures. The ideal candidate will have deep experience with both on-premises SQL Server environments and Azure cloud-based solutions. This role will involve working closely with technical teams, business stakeholders, and clients to design, implement, and maintain robust database solutions that meet business needs and support digital transformation initiatives.
Key Responsibilities:
Database Architecture and Design: Assess existing database environments (as-is state) and provide expert recommendations for designing optimal future-state (to-be) architecture, including cloud migration strategies, scalability, performance, and high availability.
Database Administration: Perform hands-on installation, configuration, patching, and upgrading of Microsoft SQL Server databases in both on-premises and Azure environments.
Azure Expertise: Design and implement Azure-based data solutions, including Azure SQL Database, SQL Managed Instances, Azure Synapse Analytics, Data Factory, and other Azure data services.
Performance Tuning and Optimization: Analyze, troubleshoot, and resolve performance issues at the database and query levels. Recommend and implement indexing strategies, query optimization, and other performance-enhancing techniques.
Advisory Role: Act as a trusted advisor to clients and stakeholders by providing insights and recommendations on database best practices, modernization, and digital transformation strategies.
Data Security and Compliance: Ensure database systems meet security and compliance requirements, including role-based access control, encryption, auditing, and GDPR or HIPAA regulations.
Disaster Recovery and High Availability: Design, implement, and manage disaster recovery (DR) and high availability (HA) solutions, including Always On Availability Groups, replication, and geo-redundancy.
Automation and Scripting: Develop and implement scripts and tools for automating routine database administration tasks, deployments, and monitoring.
Collaboration: Work closely with development, infrastructure, and DevOps teams to support the application lifecycle, including database development, release management, and continuous integration/continuous deployment (CI/CD) pipelines.
Documentation and Reporting: Maintain comprehensive documentation of database architecture, configurations, policies, and procedures. Provide regular reports and insights on system performance, usage, and optimization opportunities.
Training and Mentorship: Provide training, mentorship, and knowledge transfer to internal teams and clients to build their capabilities in database management and architecture.
Qualifications:
Education: Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
Experience: 7+ years of experience as an MS SQL Server DBA/Architect/Consultant, with a focus on both on-premises and cloud (Azure) environments.
Technical Skills:
Expertise in Microsoft SQL Server (versions 2012 to 201+) and Azure SQL Database, SQL Managed Instance, Azure Synapse Analytics, and other Azure data services.
Strong experience with database performance tuning, optimization, and indexing strategies.
Proficiency in instance consolidation strategies and practices to optimize resources and reduce costs.
Knowledge of Azure cloud architecture, including PaaS, IaaS, and hybrid solutions.
Proficiency in T-SQL, PowerShell scripting, and automation tools.
Experience with SQL Server Always On Availability Groups, clustering, log shipping, and other HA/DR strategies.
Experience with data warehousing concepts, ETL processes, and tools like SSIS and Azure Data Factory.
Soft Skills:
Excellent communication and presentation skills, with the ability to effectively convey technical information to non-technical stakeholders.
Strong problem-solving skills and a proactive approach to identifying and addressing potential issues.
Ability to work independently and collaboratively with cross-functional teams.
Strong analytical and organizational skills with attention to detail.
Preferred Qualifications:
Certifications such as Microsoft Certified: Azure Database Administrator Associate, Azure Solutions Architect Expert, or equivalent.
Experience with other database platforms (e.g., Oracle, MySQL, PostgreSQL) and NoSQL databases (e.g., Cosmos DB, MongoDB).
Familiarity with DevOps practices, CI/CD pipelines, and tools such as Jenkins, Azure DevOps, and Git.
Experience with Power BI, SSRS, and other data visualization and reporting tools.
Why work with us - At Net2Source, we believe everyone has an opportunity to lead. We see the importance of your perspective and your ability to create value. We want you to fit in—with an inclusive culture, focus on work-life fit and well-being, and a supportive, connected environment; but we also want you to stand out—with opportunities to have a strategic impact, innovate, and take necessary steps to make your mark. We help clients with new skilling, talent strategy, leadership development, employee experience, transformational change management and beyond.
Equal Employment Opportunity Statement:
Net2Source is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion or ****** orientation. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, ****** orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.
Awards and Accolades:
• America's Most Honored Businesses (Top 10%)
• Awarded by USPAAC for Fastest Growing Business in the US
• 12th Fastest Growing Staffing Company in USA by Staffing industry Analysts in the US (2020, 201+, 2020)
• Fastest 50 by NJ Biz (2020, 201+, 2020)
• INC 5000 Fastest growing for 8 consecutive years in a row (only 1.26% companies make it to this list)
• Top 100 by Dallas Business Journal (2020 and 201+)
• Proven Supplier of the Year by Workforce Logiq (2020 and 201+)
• 201+ Spirit of Alliance Award by Agile1
• 2018 Best of the Best Platinum Award by Agile1
• 2018 TechServe Alliance Excellence Awards Winner
• 2017 Best of the Best Gold Award by Agile1(Act1 Group)
Thanks & Regards
Abhishek Kumar
Sr. Technical Recruiter
201-365-4885
abhishek@net2source.com
Company address
You will be redirected to another website to apply.
Offer ID: #916634,
Published: 2 weeks ago,
Company registered: 1 year ago