Nosql DBA Technical Lead

Tata Consultancy Services Mclean , VA 22107

Posted 2 months ago

n

Responsibilities:

  • 8 + years of proven DBA experience with RDBMS (commercial and/or open source platforms)

  • Bachelor's degree in relevant field or equivalent experience. Advanced degree preferred

  • Hands on experience with AWS RDS, PostgreSQL, Aurora, MongoDB and much more

  • Demonstrable experience working with high availability, disaster recovery and performance tuning

  • Extensive scripting, automation and development experience using Shell/Python/Ansible etc. based Linux operating systems

  • Database re-platforming experience (Commercial to Open Source)

  • Experience converting on-premise RDBMS to PostgreSQL database structures

  • Experience with supporting critical databases across multiple database platforms

  • Experience with PL/SQL, T-SQL, PL/pg-SQL, stored procedures

  • In-depth understanding of common AWS data and database platforms/services and their application

  • Excellent leadership, team-player, peer management, communication & presentation skills

  • AWS certification on SysOps Administrator Associate or Professional is preferred

  • Experience with Agile and configuration management tools

  • AWS,

  • Build, configure and maintain data & database platforms as per standards

  • Design, document, test and implement solutions for monitoring, maintenance, and performance

  • Support hardware and software technology upgrades

  • Review performance, capacity, workload and take actions

  • Proactively work on database enhancements to improve system performance and stability

  • Troubleshoot production problems and lead incident management calls as a database SME

  • Interact with incident & problem management on root cause analysis (RCA) and permanent remediation actions

  • Collaborate on build specifications and actual buildouts of database environments

  • Automate implementation of the database components in accordance with CI/CD standards

  • Participate in 24x7 production on-call support on rotation basis

  • Create & document standard operating procedures & best practices.

Qualifications:(Please list all required qualifications) RDBMS, SQL Server, AWS RDS, PostgreSQL, Oracle DBA, Mongo DB

Questions for Internal and Total Rewards:

  1. Years of experience required for position 10+ Years

  2. Location for the position : McLean, VA


LI-BA1

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
Performance Test Engineering Technical Lead

Freddie Mac

Posted 4 weeks ago

VIEW JOBS 8/25/2020 12:00:00 AM 2020-11-23T00:00 Job Description At Freddie Mac, you will do important work to build a better housing finance system and you'll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation. Position Overview: The Testing Tech Lead is accountable for strategy and delivery of Performance testing. This individual will interact with Business/ IT Sr. management and staff throughout the project life cycle, to drive and support the design, development and implementation of Performance testing practices for applications and web services. They will provide oversight and direction to performance engineers and communicate strategy and progress to project leadership teams. They will provide directions and expertise to analyze project performance issues and help drive multi-functional swat teams if needed. They will be accountable to communicate test findings and lead test reviews to communicate and gain acceptance of performance test results. They will collaborate with IT staff and project areas in resolving questions during the testing process. Works with IT management and staff to establish and maintain a consistent test methodology. This role will require the individual to have superior expertise in performance testing to provide direction and assistance to performance test engineers and project development teams! Our Impact: This role will be accountable to ensure the performance test strategy and test assets meet the goals for projects. They will be responsible establish standards and approaches to meet performance testing needs. Your Impact: You will provide direction and expertise to analyze project performance issues and help drive multi-functional swat teams if needed. You will be accountable to communicate test findings and lead test reviews to communicate and gain acceptance of performance test results. You will collaborate with IT staff and project areas in resolving questions during the testing process. This role will require the individual to have superior expertise in performance testing to provide direction and assistance to performance test engineers and project development teams. Qualifications: * 8-10 years of experience * Computer Science Graduate or equivalent Bachelor's Degree or work experience * Design, approach, and the development of the performance test scripts and workload executions across multiple projects to ensure that software meets or exceeds specified performance nonfunctional requirements. * They will provide direction for design/develop of performance test solutions to other mid-level performance test engineers. * Publish and communicate test results. Communicate application related technical issues to the application tech leads and project team's management and contributing towards recommended solutions. * Lead swat teams to organize multi-functional teams to identify/resolve issues and as needed provide analysis and niche expertise. * Accountable to establish standards and directions to develop/enhance performance workload distribution test models based on production usage transaction mix and/or business projections. This may require education to be provided to system analysts and business personnel to assist with the creation of performance requirements. * Provide approaches to Simulate number of concurrent/Active/Simultaneous users for load scenarios to determine response times and bottlenecks. * Provide directions to establish monitoring tools and resources and collect metrics during the tests in order to determine the impact of load/stress testing on the infrastructure. * Responsible for understanding nonfunctional performance requirements, provide directions to establish test plans, strong knowledge in performance testing life cycle, approaches to executing test cases (GUI, Web Service Request, and Back End/ DB), understanding of the data models, reporting to the test manager. * Good experience in tool problem solving or debug issues. * Provide directions team members to setup DevOps by configuring performance testing tools to CI/CD pipeline or freestyle jobs to support continuous testing. * Responsible to influence project teams and performance team members to design, develop and adopt service virtualization approaches. * In-depth knowledge and understanding of tools such as HP Performance Center/Load Runner, JMeter, System Monitoring tools for Unix and Windows environment, Application monitoring Tools like Opnet, Site scope, intro scope, etc…, Test Management and Defect Tracking tools, Understanding of J2EE, and SOA architectures, Jenkins, Service Virtualization tools like Smart Stub etc. Keys to Success in this Role: * Self-Motivated and Continuous learner Current Freddie Mac employees please apply through the internal career site. Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you'll do important work for the housing finance system and make a difference in the lives of others. We are an equal opportunity employer and value diversity and inclusion at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by applicable law. We will ensure that individuals with differing abilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit www.BountyJobs.com and register with our referral code: MAC. Time-type:Full time Job Category:Information Technology FLSA Status:Exempt Freddie Mac Mclean VA

Nosql DBA Technical Lead

Tata Consultancy Services