Job Description :
Company Overview:
Pactera is a global company offering consulting, digital, technology and operations services to the world’s leading enterprises. From our roots in engineering to the latest in digital transformation, we give customers a competitive edge. The Data Services team within Pactera is looking for a senior SQL Architect who can drive the technology transformations with our clients
The architect will bring a passion for technology, strong technical acumen and business understanding, and demonstrated experience in deploying production-ready solutions for our customers.
He/She will be aligned with high visibility customers to provide migration/modernization consulting services.
Job Responsibilities
Technical Lead on Database projects including designing solutions, perform POCs and assisting Level 2 and Level 3 DBAs in development and implementation of solutions
Develop database architecture roadmaps in support of business strategies
Lead in solution architecture for databases and database applications
Participate in security architecture reviews of enterprise systems
Responsible for aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment
Defining hardware specifications for the installation of SQL Server databases, analysis services, integration services, reporting services
Contribute to planning, designing and deploying data warehouses, data marts and transactional databases
Participate in activities that ensure the successful use of these systems including: developing documentation, test scripts, and training materials
Plan and conduct database architecture assessments that examine DBMS and database configuration and performance
Review and assess existing enterprise data-driven applications, support new features, performance improvements, upgrades
Analyze large, complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency
Capture and analyze database activity to identify improvements in storage, indexing, file structure, maintenance processes, and query performance
Experience working with a support team on production support, including familiarity with formal support processes
Required Experience and Skill Sets
At least 10+ years of experience with Database administration and other MSSQL Server architecture related aspects
Experience designing, deploying, and maintaining SQL Server infrastructures on version 2008/2012/2014/2016 with preference on experience with SQL 2016
Experience with in memory database and column store indexes
At least 1 year of exposure/experience with competing database platforms like (Oracle/DB2/Teradata)
Experience developing and presenting roadmap and solution architecture documentation
Proficiency with managing and administering SQL Server installations and databases including: developing maintenance plans, configuring server resources, monitoring performance, configuring instances and databases, partitioning, indexing, identifying data base vulnerabilities and administering security
Expert level skills designing and implementing redundant and scalable SQL Server infrastructures using technologies including database mirroring, log shipping, replication, Always On Availability Groups, etc.
Proficiency with SQL Server Integration Services, SQL Server Reporting Services, SQL Analysis Services, SQL Profiler, and SQL Server Management Studio
Experience designing, implementing, supporting, and analyzing enterprise scale applications that perform extract/transform/load (ETL) operations with external data sources and SQL Server
Experience in Performance Tuning and Optimization using native monitoring and monitoring tools.
Experience defining backup strategy, performing backups, restores and disaster recovery.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Experience in implementing operational automation using scripts.
Other Attributes
Very strong communication skills
Bachelor’s degree in computer science, information systems, or equivalent work experience.
Independent thinking and self-driven
Certification is a plus; MCTS, MCITP, MVP
Experience implementing Cloud/Azure solutions a plus