Senior Ms-Sql Server Migration Expert

Mphasis Limited New York , NY 10007

Posted 5 days ago

Job Description:

Role: Senior MS-SQL Server Migration Expert

Location: Phoniex ,AZ ,USA

Duration : Only Full time.

"Must have the ability to work in the US without current/future need for Mphasis Sponsorship".

Who are we looking for?

  • A mid-senior level SQL Server lead to manage a critical project for one of our biggest client in BFSI domain. The Individual should be passionate about technology, experienced in developing and managing cutting edge technology applications.

Technical Skills:

  • Seven or more years of experience in EOSL database migration using 2012, 2014 and 2016 versions.

  • Should have lead database migration projects end to end

  • Should have migrated 100+ SQL Instances to SQL 2016 /SQL 2019.

  • Strong experience in Pre and Post migration consultancy & procedure

  • Strong performance tuning skills in a very large database environment.

  • Experience in writing PS script for automation

  • Experience in using various SQL migration tools like SSMA,DMA,DME

  • Seven or more years of experience in database administration using SQL 2012, 2014 & 2016 versions.

  • Ability to use SQL Trace , Perfmon, PAL reports to analyze results, then to recommend options for problem resolution.

  • Expert level knowledge in writing T-SQL queries.

  • Strong experience with SQL backup/recovery methodologies.

  • Strong experience with Windows cluster, Database mirroring, Always-On,DAG, Replication and other HA/DR functions within SQL Server.

  • Must be able to organize work efficiently and work well under stress, changing priorities, and time constraints.

  • Familiar with compliance guidelines like SOC 1 Type 2, S-OX is a plus.

  • Having sound knowledge of ITIL practices like Change Management, Incident Management etc.

Process Skills:

  • Help with Data Center migration and migrating on premise db servers to new servers.

  • Develop data migration sub-project plans with Project Manager.

  • Responsible for planning and designing MS SQL Server database specifications, understanding database definition, structure, and long range requirements.

  • Support customer troubleshooting and problem solving during data verification.

  • Define, track, and maintain standard baselines and configuration sets of all managed and/or monitored database instances and servers and implement industry best practices with regards to the following:

  • Resource allocation and monitoring

  • Performance problem identification and resolution assistance

  • Data security and recovery

  • Data and database health practices

  • MS SQL Server patch management and System capacity planning.

  • Develop and maintain storage strategies, establishing system documentation and database recovery processing.

  • Identify and initiate resolutions to user problems associated with database performance and database capacity, utilizing best practices to maximize up time and server utilization.

  • Review and deploy the database components for new versions of web applications/products to test and production environments using release management practices.

  • Willingness to provide support in non-business hours,weekend, bi-weekly on-call rotation for support.

Responsible for DR tests on regular basis.

Behavioral Skills:

  • Must have superior problem-solving skills with extremely high levels of initiative and assertiveness.

  • Effective interpersonal, team building and communication skills

Qualification:

  • Bachelor's degree preferably in Computer Science or Information Systems and /or equivalent formal training or work experience.

  • 5-7 years of relevant experience in relational database management systems.

  • Seven or more years of experience in EOSL database migration using 2012, 2014 and 2016 versions.

  • Should have lead database migration projects end to end

  • Should have migrated 100+ SQL Instances to SQL 2016 /SQL 2019.

  • Strong experience in Pre and Post migration consultancy & procedure

  • Strong performance tuning skills in a very large database environment.

  • Experience in writing PS script for automation

  • Experience in using various SQL migration tools like SSMA,DMA,DME

  • Seven or more years of experience in database administration using SQL 2012, 2014 & 2016 versions.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Cloud Application Migration & Modernization Consultant

Amazon.Com, Inc.

Posted 1 week ago

VIEW JOBS 10/16/2020 12:00:00 AM 2021-01-14T00:00 Amazon Web Services (AWS) is looking for highly talented hands on technical architects to help accelerate our growing Application Migration business. This is an excellent opportunity to join Amazon's world class technical teams, working with some of the best and brightest engineers while also using and expanding your skills working hands on with the future of everything. AWS Professional Services engages in a wide variety of projects for customers and partners, spanning diverse technologies across multiple industries. The Application Migration and Modernization Practice collaborates across the entire AWS organization to deliver the best solutions for customers, connect with AWS product and service teams, and drive feature innovation based upon customer needs. As trusted customer advocates, the Practice helps organizations understand best practices around advanced cloud-based solutions, and how to migrate and/or re-develop existing workloads in the cloud. You will help shape, execute, and deliver solutions for a broad range of customer use cases primarily from large enterprise customers. This is not a pure consultant role, nor is it a pure selling role. It is an individual with a unique application modernization and cloud native application development expertise, hands-on building, coupled with cross-industry business acumen, including a heavy dose of passion for continued knowledge acquisition and growth, obsession for customers, and their success using AWS that will align well with the desired outcomes to be produced. In this role as an experienced cloud architect/developer, you will work with our customers in architecting, developing and re-engineering applications that can fully leverage the AWS Cloud. You will work on a variety of game changing projects, at the forefront of application development and cloud technology adoption. Achieving success will require coordination across many internal AWS teams and external AWS Partners, with impact and visibility at the highest levels of the company. An ideal candidate will be able to: * Helping customers architect scalable, highly available application solutions that leverage AWS services; * Architecting and developing customer applications to be cloud optimized; * Working as a technical leader alongside customer business, development and infrastructure teams; * Providing deep software development knowledge with respect cloud architecture, design patterns and programming; * Advising and implementing AWS best practices; * Working as both an infrastructure and application development specialist; * Agile software development and DevOps; and * Implementing DevOps practices such as infrastructure as code, continuous integration and automated deployment. This is a customer-facing role. You be required to travel to client locations to deliver professional services when needed. * Practical application development experience on Linux and Windows-based systems using Agile methodologies. * 7+ years of enterprise grade application development and design experience; * Experience with CI/CD tools; automated testing tools (e.g. Junit, TestNG); CloudFormation, Terraform; relational databases (Oracle, SQL Server, PostgreSQL, MySQL) or NoSQL databases (Cassandra, MongoDB, DynamoDB); Java, .NET (C#), Python, Node.js, Ruby, C/C++, or Scala; configuration management platforms (e.g. Chef, Puppet, Salt, or Ansible); * Experience architecting highly available systems that utilize load balancing, horizontal scalability and high availability; * Experience in a customer facing role driving discussions with business and technical personnel regarding design, development and architecting best practices; * BS level technical degree required; Computer Science or Math background preferred; MS degree desired; * Able to work in a diverse team * Extensive experience developing, designing and developing applications in an AWS Cloud environment; * Experience migrating applications from one OS to another (ex. Solaris to Linux) or from one database to another (ex. Informix to Oracle); * Experience with converting monolith applications to microservices on AWS; building cloud-native applications on AWS; * Demonstrated ability to think strategically about business, product, and technical challenges; * Verbal and written communications skills and ability to work effectively across organizations; and * Integration of AWS cloud services with on premise technologies from Microsoft, IBM, Oracle, HP, SAP etc.; * Advanced degrees in information systems, engineering and/or business. Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us. Amazon.Com, Inc. New York NY

Senior Ms-Sql Server Migration Expert

Mphasis Limited