dropship tollfree contactus
Perfume Worldwide


We are in need of candidates for the following positions:


Send your resume to: careers@perfumeworldwide.com




Database Administrator

Posted: 05/15/2020

As a Database Administrator you will be responsible to maintain and migrate all databases in MS SQL, MySQL and Oracle. As a member of a team consisting of Front-End Developers, a Full-Stack Developer, QA, Business Analysts, and a Scrum master, you will build databases required for back-end technology to create a seamless experience for customers as well as internal stakeholders. The work you do will be central to how Perfume Worldwide achieves quality.

RESPONSIBILITIES:
 

  • Monitoring databases, which include basic health checks, growth of objects, performance of the database and giving recommendations how to resolve it.
  • Configured Database Mirroring with high performance and high availability mode.
  • Reviews description of changes to database design to understand how changes affect how data is stored in terms of location, amount of space, and access method.
  • Update entire environment to SQL Server 2016 from SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 utilizing PowerShell.
  • Involved in Moving System databases.
  • Managing server and database roles to meet audit requirements High availability solutions and disaster recovery.
  • Implementing and maintaining database security (create and maintain users, roles and assign privileges).
  • Monitored the event logs and server logs for troubleshooting and problem solving
  • Implemented different types of replications Transactional, Snapshot and merge replications.
  • Identify areas for refactoring and improvements as changes are made.
  • Migrated databases from SQL Server 2005 to SQL Server 2008/2008R2 databases.
  • Support developers and project managers on database requirements, performance issues and optimum space requirements.
  • Responsible for overseeing the company's requirements, development, testing and deployment of Microsoft CRM projects.
  • Customizing and configuring CRM system at a user level.
  • Responsible for converting business requirements into technical requirements for development team.
  • Maintain and monitor all redundancy and disaster recovery configurations for SQL systems including but not limited to data replication.
  • Ensure all developed SQL Server components function flawlessly in a production environment with stringent uptime standards.
  • Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
  • Migrating MySQL database from 5.1 to 5.6 with all data without effecting client applications.
  • Administers all SQL database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
  • Experience with backup strategies, clustering, high-availability (Always On Availability Groups), replication and DR solutions for SQL a must, review database design and make recommendations regarding enhancements and/or improvements.

MINIMUM REQUIREMENTS:


  • Bachelor’s degree required in Computer Science or Computer Engineering or Information Technology Management or Computer Information Systems.
  • In-depth understanding and experience working with different databases like MS SQL, MySQL, Oracle.
  • Experience with MS SQL Server Standard and Enterprise 2008 and SQL 2012; SQL 2014
  • Proven experience deploying production quality MS SQL database, stored procedures, DTS and SSIS packages.
  • Excellent verbal and written communication skills.
  • Minimum Bachelor’s degree in computer science or computer engineering or Electrical/Electronics and Computer Engineer is required.
  • Proficient in Office 365 Products (Including SharePoint).
  • Excellent customer service skills.
  • A results oriented individual who thrives working in a fast paced environment.

 
Home   |   Careers   |   Contact Us
© 2021 Perfume Worldwide, Inc. All rights reserved.   
SSL Certificate
SSL Certificate