Jeffrey — database analyst
Jeffrey
Industries Served
Work History on Automate America
Secure & Personal Files
Documents on file. Only Jeffrey and Automate America admins can view or download them — except the background check, which is shared with a customer when they shortlist Jeffrey.
- Resume✓ On file
Programming Skills (3)
About Me
My name is Jeffrey and as a resourceful, results-oriented, and highly analytical Senior Database Administrator, I possess the strategic, critical-thinking, and investigative problem-solving skills necessary to deliver comprehensive support for intricate systems and databases.
I am fully equipped to tackle complex challenges leveraging my educational achievement of a Bachelor of Science in Computer Science, along with my more than 23 years of hands-on expertise in application development, infrastructure management, database architecture, end-to-end project management, SQL Server management, as well as coding, testing, debugging, and disaster recovery.
Some highlights of my career have been:
● My exceptional track-record of delivering consultative expertise in the position of Microsoft SQL Server DBA/SQL Developer. Successfully created an SSRS implementation for the CMS Psychosocial Assessment report- a complex 12-page report equipped with 628 checkbox fields and 130 text fields.
● As a Consultant-Sybase DBA, I wrote 3 Perl programs to perform an index audit of 24876 index DDLs; modified a production SQL query to run in one second; and recuperated a corrupt 1.5 million row data row locked database table using BCP 10.0.4 and non-clustered index coverage. My advanced project management skills allow me to lead all phases of the project and product lifecycle in support of client and project objectives.
Please feel free to connect with me via LinkedIn, or email me directly at to discuss how I can utilize my hands-on experience, expertise and education to help your organization excel.
Skilled Trades (1)
Software Competencies (1)
Professional Competencies (5)
Work Experience(5)
Some of my achievements in this role consisted of: I successfully facilitated migration of a comprehensive in-house ClientTrack application system to the SQL Azure and cloud-based ClientTrack 2015. I conceptualized and created SSRS implementation for the CMS Psychosocial Assessment Report consisting of a 12-page report with 628 checkbox fields and 130 text fields
In this role, I planned and delivered onsite Microsoft SQL Server DBA and SQL Developer support services to reinforce a small non-profit organization responsible for coordinating healthcare and social services for HIV and AIDS patients. Some of my achievements in this role consisted of: ● I successfully facilitated migration of a comprehensive in-house ClientTrack application system to the SQL Azure and cloud-based ClientTrack 2015. ● I conceptualized and created SSRS implementation for the CMS Psychosocial Assessment Report consisting of a 12-page report with 628 checkbox fields and 130 text fields.
As a Sybase DBA Consultant and IBM Contractor, I delivered valued remote Sybase production DBA support and assistance as well as product support for the following: Sybase ASE, IQ, Replication Server, and SQL Anywhere products. Some of my achievements in this role consisted of: ● I skillfully utilized my outstanding script design skills to create and write 3 Perl programs to perform an index audit of 24876 index DDLs; and Korn Shell and cmd.exe scripts to integrate IBM Blue Care monitoring software into the customer's Replication Server, Sybase IQ and Adaptive Server Anywhere production server estates. ● I improved performance by auditing 40 user databases on a Sybase production instance in addition to managing Sybase RDBMS migration feasibility for selected applications. ● I closely tracked track performance and configuration changes of a clustered and mirrored production SQL Anywhere 12.x application system by organizing and constructing an SQL Anywhere database repository.
As a member of the Global Markets DBA team, I delivered Sybase production DBA support services and primary DBA support services to the Markets Derivatives group in Latin America, Asia, Australia, Canada and the United States. Some of my achievements in this role consisted of: ● I drove marked improvement in productivity by creating and implementing a reporting mechanism to effectively extract, parse, and convert database instance vulnerability assessment data embedded in PDF files into XML files. ● I conducted in-depth data analysis to generate reports on database and filesystem growth.
Education / Training / Certificates(1)
Frequently Asked Questions
- What does Jeffrey do?
- Jeffrey is a database analyst on Automate America, the global professional marketplace for skilled talent across industrial, commercial, and residential work.
- Where is Jeffrey located?
- Jeffrey is based in Corona, California.
- What does Jeffrey specialize in?
- Jeffrey works with IBM, Microsoft SQL Server, Oracle, Support as a database analyst on Automate America, the global professional marketplace for skilled talent across industrial, commercial, and residential work.
- Is Jeffrey available for work?
- Availability unknown. Jeffrey has not marked it recently.
- How do I connect with or hire Jeffrey?
- Create a free profile on Automate America and send a connection or contract request from this profile. Jeffrey can then respond and coordinate the work directly through the platform.