JobsEQ by Chmura Logo

Database Administrator/Developer

Mezrah Consulting

Location: Tampa, FL, 33607
Type: Full-Time, Non-Remote
Posted on: May 4, 2021
This job is no longer available from the source.
Job Description DATABASE ADMINISTRATOR / DEVELOPER
Position Description: The Database Administrator serves as a Database Engineer (DBE) and is the
central contributor in designing and implementing major pieces of core
database infrastructure. The DBA/DBE acts as the internal "database expert"
within the Agile development team. The DBA/DBE influences the deployment
strategy and operational strategy for the organization's use of databases. The
DBA/DBE designs major core database services such as replication, data high
availability, disaster recovery, implementation of database techniques and
features to support service scalability, and performance and stability for
SaaS platforms. The DBA/DBE works closely with the Agile development team to
test and deploy infrastructural enhancements. Resolves complex technical
issues and improves system availability, resiliency, and performance. Work is
non-routine and very complex, involving the application of advanced technical
and business skills in database engineering. The DBA/DBE designs, develops,
troubleshoots, and debugs software programs for databases, applications,
tools, networks, etc. The DBA/DBE will also work closely with our Salesforce
platform to implement new enhancements as well as maintain the existing
codebase.
Responsibilities:
* Develop solutions in .NET, C#, SQL, Apex, Visualforce and various API libraries
* Ensure the Salesforce platform and SQL server remain in sync.
* Manage the day to day operations of our existing SQL Server infrastructure, from development to
production; This includes monitoring performance, jobs, replication, and backups
* Future proofing our SQL server by ensuring queries, procedures, and custom developed solutions run
in a timely and optimized manner for current data capacity and future estimated data capacity
* Assist application developers with complex query tuning and schema refinement
* Optimize current SQL server solutions and assist the agile development team in designing optimized
systems
* Ensure SQL server infrastructure meets scalability requirements for future needs by identifying
potential future concerns and researching solutions for them
* Research and stay up to date on our SQL server infrastructure (Amazon Web Services)
* Review SQL server logs and ensure the server behaves as expected on a day to day basis
* Management of the SQL server database's architecture in the Amazon Web Services platform
* Identify potential risks or threats to our SQL server database (e.g. security threats, end of life
or end of support, etc.) and provide recommendations
* Manage any data transitions required due to end of life/support or server migration
* Follow defined and de facto development standards
* Participate in code reviews
* Ensure assigned technical tasks are being delivered on time and with quality
* Provide production support and all related ancillary program.
* Support the entire product development lifecycle including requirements gathering and analysis,
functional design, technical design, coding, testing, implementation, and post implementation
support & maintenance
* Analyze, design, and implement robust, maintainable solutions that meet the established business
requirements utilizing creative thinking and problem-solving skills
* Develop and maintain technical and project documentation
* Develop unit tests and test plans in order to work with the QA team to establish quality test
processes
* Follow current development trends and provide recommendations for new development strategies and
tools
* Make suggestions to management on current and emerging technologies, on methods to reduce costs,
improve performance and availability, and reduce administration time
* Other development duties which may be necessary to fulfill optimum efficiency of the position
Qualifications:
Desired Experience and Skills:
* 2+ years MS SQL Server administration experience, including high availability, replication,
performance tuning, SSIS, SSRS, database backup & restores
* 1+ years of Amazon Web Services (AWS) experience managing cloud servers
* 1+ years of development experience using an object-oriented language
* 1+ years of designing and managing networks in the AWS environment
* Ability to write efficient, complex queries
* Ability to resolve database performance and capacity issues, replication and other distributed
data issues
* Proficient knowledge on related technical skill sets and technologies including but not limited to
SQL Server, SSRS, SSMS, C#, and Java. (Javascript, HTML5, CSS, APEX, Visualforce, Agile development,
REST, SOAP, and distributed version control a plus)
* Knowledge of customer relationship management (CRM) platforms such as Salesforce
* Ability to work effectively with a variety of constituents (Architecture, Configuration
Management, Quality Assurance, Business Analysts, Other Development Teams, Business Customers)
* Understanding of user interface design and user experience
* Working knowledge of effective problem solving and identifying innovative solutions
* Proficient analytical skills, including the ability to evaluate existing or proposed new solutions
for potential flaws or improvement opportunities - including alignment to departmental goals and
standards
* Working ability to navigate complex environments and work with interdisciplinary teams and
effectively communicate priorities, deliver expectations, risks and concerns to management
* Demonstrate solutions development ability, including innovative thinking, creative problem
solving, and the ability to execute quickly while maintaining high quality expectations
* Proficient written and verbal communication skills in English, including the ability to explain
complex ideas to others with varying levels of expertise throughout the organization and with
potential business partners
* Proficient organizational skills, with the ability to handle multiple, overlapping, and
potentially conflicting priorities
* Proficient ability to remain highly effective under stress and respond to pressure in a manner
acceptable to others and to the organization
* Proficient knowledge of services design patterns, principles, and practices
* Proficient experience working with developing and supporting scalable services technologies with
strict SLAs and high throughput
* Bachelor's degree from an accredited program in Computer Science, Computer Science Engineering or
related academic discipline required
* Knowledge of financial markets and trading
Job Requirements
.
Desired Experience and Skills: * 2+ years MS SQL Server administration experience, including high availability, replication, performance tuning, SSIS, SSRS, database backup & restores * 1+ years of Amazon Web Services (AWS) experience managing cloud servers * 1+ years of development experience using an object-oriented language * 1+ years of designing and managing networks in the AWS environment * Ability to write efficient, complex queries * Ability to resolve database performance and capacity issues, replication and other distributed data issues * Proficient knowledge on related technical skill sets and technologies including but not limited to SQL Server, SSRS, SSMS, C#, and Java. (Javascript, HTML5, CSS, APEX, Visualforce, Agile development, REST, SOAP, and distributed version control a plus) * Knowledge of customer relationship management (CRM) platforms such as Salesforce * Ability to work effectively with a variety of constituents (Architecture, Configuration Management, Quality Assurance, Business Analysts, Other Development Teams, Business Customers) * Understanding of user interface design and user experience * Working knowledge of effective problem solving and identifying innovative solutions * Proficient analytical skills, including the ability to evaluate existing or proposed new solutions for potential flaws or improvement opportunities - including alignment to departmental goals and standards * Working ability to navigate complex environments and work with interdisciplinary teams and effectively communicate priorities, deliver expectations, risks and concerns to management * Demonstrate solutions development ability, including innovative thinking, creative problem solving, and the ability to execute quickly while maintaining high quality expectations * Proficient written and verbal communication skills in English, including the ability to explain complex ideas to others with varying levels of expertise throughout the organization and with potential business partners * Proficient organizational skills, with the ability to handle multiple, overlapping, and potentially conflicting priorities * Proficient ability to remain highly effective under stress and respond to pressure in a manner acceptable to others and to the organization * Proficient knowledge of services design patterns, principles, and practices * Proficient experience working with developing and supporting scalable services technologies with strict SLAs and high throughput * Bachelor's degree from an accredited program in Computer Science, Computer Science Engineering or related academic discipline required * Knowledge of financial markets and trading At least 3 years experience. $55000-$65000 per YEAR Employment Type: Full-Time