Sr Database Engineer - Mexico City , México | STAND 8 Careers | Stand8

Sr Database Engineer
Back to Job Search
Sr Database Engineer
Date Posted:  4/26/2021
Job ID:  Job #3559
Employment Type: Contract
Location: Mexico City México
Submit Resume
SHARE THIS JOB POST
We are hiring for a Sr. Database Engineer. If you are ready to create an impact in a collaborative and fast-paced environment, this could be a great opportunity for you!
STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in LA, Atlanta, New York, Mexico and more.
This position will start remote, but must be able to work on site in Mexico City in 2021. 

JOB DESCRIPTION 
You will be responsible for designing and implementing product enhancements, creating and modifying PL/SQL packages, redesign of existing product functions, troubleshooting and resolving product defects, unit and integration testing. Active interaction between on-shore and off-shore team members, internal customers, other developers, Quality Assurance, Business System Analysts, Tax Research, Professional Services, and Customer Support counterparts is an integral part of the role.

RESPONSIBILITIES
  • Designing database schema that produce high performance software solutions in service-oriented architectures
  • Programming and unit testing of code based upon design sessions with internal software users, customer-reported issues, and input from Business System Analysts, Marketing, Professional Services, and Support
  • Unit and performance testing of design as part of development cycle
  • Developing and re-factoring existing products, providing product enhancements and resolving product defects to meet customer issues
  • Providing technical expertise and peer code reviews to other team members
  • Providing architectural input on new and existing solutions
  • Writing technical specifications, program documentation, and unit test plans for all work performed
  • Maintaining solid relationships with cross-functional peers and offshore team
  • Assisting in Quality Assurance process and customer issue resolution
  • Partnering with Quality Assurance to drive high-quality, on-time deliverables.
WORK EXPERIENCE REQUIREMENTS 
  • Bachelor’s in computer science or equivalent work experience
  • 5+ years’ working with Oracle 11g/12c database design and data architecture experience
  • 3+ years’ specifically working with PL/SQL variant (Oracle)
  • Experience with PL/SQL, Packages, stored procedure development and data modeling
  • Experience in debugging and understanding complex, unfamiliar PL/SQL code
  • Practical experience with large databases containing tables with billions of rows and terabytes of data
  • Experience using Oracle packages (dbms, ctx, utl etc.), procedures, views, materialized views
  • Experience working with XML and JSON
  • Familiarity with third party tools such as TOAD, SQLNavigator, or SQLDeveloper
  • Experience with SQL Loader
  • Experience with nested tables, user defined functions, packages and triggers, external and partition tables, bulk processing
  • Experience with ETL processing and patterns, implementations and tools along with writing scripts to load/manipulate data between different databases
  • Should be able to perform ETL processes using PL/SQL with/without third party tools
  • Database performance tuning and job scheduling in oracle
  • Additional experience working with other databases such as MySQL, SQL Server, and PostgreSQL is also desirable
  • Demonstrated ability to work as part of a team, as well as independently
  • Solid work ethic, self-driven with the ability to work with minimal supervision
  • Experience using Agile-based methodologies within a software development function
  • Experience with full life cycle development: requirements gathering, analysis, design, coding, unit testing, and acceptance testing
  • Strong working knowledge with Object-Oriented Analysis, Design, and Implementation
NICE TO HAVE 
  • Linux/Unix Bash, Perl or Python script writing is a plus
  • Non-relational database technologies (NoSQL)
  • Experience working with Java/J2EE and web technologies is a plus
  • Big Data frameworks and implementations (Hadoop, MongoDB, etc.)  is not mandatory but would be a plus
  • Applying Design Patterns and Enterprise Application Integration Patterns
  • Prior work experience in a fast-paced, high-energy environment
  • Performance testing, analysis, and tuning experience
  • IntelliJ IDEA IDE
SKILLS REQUIRED 
  • Strong analytical and design skills
  • Highly accountable for meeting all commitments and deadlines
  • Effective communication skills, both written and verbal for technical and non-technical audiences
  • Must be able to work independently as well as collaboratively
  • Drive for continuous process improvement