|
Posted: 02/01/2018
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:
- Maintain SQL database that supports Dynamic CRM which maintains all 3pl related account transactions.
- Planning and executing database monitoring, maintenance, patching and upgrades, and working with infrastructure teams for scheduled maintenance and upgrades
- Work with the other database administration team members, resolve technical issues and help estimate and schedule tasks
- Define database authorization rules, perform security audit, and perform platform assessment regarding proper support for the selected databases. Read and implement entity-relationship diagrams
- Responsible for database backups, recoveries, patches, upgrades and performance tuning.
- Design and develop complex database design from high level business requirements. Must be able to provide database design options, alternatives and recommendations based on experience and best practices for database design
- Establish standards for documentation and ensure that all designs are documented other tasks as assigned.
- Install and configure database environments and associated storage systems.
- Develop new and improve existing stored procedures, Data Transformation Services, SSIS and MS SQL Server databases.
- Assigns passwords and maintain database access, audit database access and requests.
- Support and develop multiple SQL Server Databases and data replication subsystems.
- 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:
- 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.
|
