Albert James
System Engineer at DAn Solutions, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Microsoft Certified: Azure Database Administrator Associate
MicrosoftAug, 2021- Nov, 2024 -
Oracle Database 12c Administrator Certified Associate
OracleJul, 2021- Nov, 2024 -
Oracle Certified Professional, Java EE 5 Web Component Developer - JPN
OracleDec, 2012- Nov, 2024 -
CompTIA Security+ ce Certification
CompTIAMar, 2017- Nov, 2024
Experience
-
DAn Solutions
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
System Engineer
-
May 2019 - Present
• Provided 24/7 on call production support.• Managed 250+ Production SQL Servers in Virtual Environments.• Experience on installation, configuration and migration of SQL Server 2005, 2008 R2, 2012, 2016 on Windows 2012 and 2016, applied service packs and security fix for all servers.• Involved in development activities like database design, architecture and SQL scripting.• Specialized in RDBMS design using normalization techniques and expertise in using SQL and PL/SQL to write and dugging Stored Procedures, Functions, Packages and Triggers.• Implemented Database Mirroring on SQL Server 2008 R2/2012 and established AlwaysOn Availability Group (AOAG) with cluster environments.• Proficient in using Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks / long running queries.• Upgraded SQL Server from OS Windows 10/2008 R2 to OS Windows 10/2012.• Upgraded SQL Server from OS Windows 10/2012 to OS Windows 16/2016.• Managed multiple SQL Server instances in Active/Active and Active/Passive clusters.• Installed and configured Async and Sync Mirroring for Production and DR environments.• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
-
-
-
ABSC (Absolute Business Solutions Corp.)
-
United States
-
Defense & Space
-
1 - 100 Employee
-
Junior Database Administrator
-
Dec 2016 - Jul 2019
• Performance monitoring through SSMS and utilization of Powershell scripts (such as but not limited to• index re-organization or rebuilding indexes)• Perform SQL Server 2012 installations (also including SSAS, SSRS)• Upgraded SQL Server 2008 to SQL Server 2012• Upgraded SQL Server 2012 to SQL Server 2016• Validate database backups by performing backup restoration• Manage over 100+ databases• Troubleshoot server errors along with SQL Server errors• Create, configure, and manager Windows Clusters• Add, manage, and create High Availability Groups (HADR), and mirroring, for continuation of service in• the event of disaster or failure• Assist in development of customize client tools created by developers• Perform data migration from 2008 servers to new servers• Assist SharePoint team by ensuring connection to SharePoint web front servers• Responsible for backing up databases, and placing databases in either Simple or Full recovery model,• and conduct Full, Differential, and Transnational Logs for specific point-in-time-recovery.• Secure access to databases by giving least privileges needed by applying users to groups with certain• level of privileges.• Conduct monthly HADR fail-over to ensure in the case of an emergency fail-over can be conducted with• no problems.• Security Technical Implementation Guides (STIGs)• Assist in the remodeling and/or creation of a database• Work on documenting database environments and standard operating procedures(SOP).
-
-
-
U.S. Department of Homeland Security
-
Government Administration
-
700 & Above Employee
-
Oracle Database Administrator
-
Apr 2011 - May 2016
Initiates daily Recovery Manager (RMAN) backups of database for restoral and recovery efforts in compliance with business objectivesAdministers, maintains, and implements policies and procedures for ensuring the security and integrity of the databaseConducts database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AutomaticWorkload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)Collaborates with database developers and programmers to further development processesManages database administration, troubleshooting, and configuration of the database environment – resolves issues of performanceAnalyzes user trace files and alert logs, identifying and mitigating the issueCreates users, tablespaces, schemas, and various database objects as well as resource management through Oracle Enterprise Manager (OEM)Developed SQL scripts to perform the daily Database & OS monitoring, Server validation & health checkUtilized SQL* Loader to migrate or load data to OracleOptimized database performance through various instance configurations and SQL TuningIdentifies Oracle bugs and applies quarterly oracle security patches to standby and primary databases.Implements physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM)Monitors and manages Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11gUltize third party application tools such as; TOAD, Tivoli, CRON to assist database productivity
-
-
-
Jenkins Consulting
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Junior Database Administrator
-
Sep 2008 - Apr 2011
Configured the necessary parameters for Flashback database settings and Flash Recovery Area, then used RMAN to issue Flash Recovery CommandsImplemented Flashback technology of Oracle 11g, 10g along with Recycle bin for quick recovery of the databases and database objectsManaged databases and instances using DataGuard, RAC in a real time production, testing, and developmentenvironmentsCreated database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQLMaintained database schemas and dictionaries utilizing knowledge of Data Dictionary Language (DDL) andData Manipulation Language (DML) tools, and conducted PL/SQL scripting and codingRestored schema objects for database users utilizing logical backupResolved database issues such as fragmentation and table space sizing.Collaborated with development team in database performance issues and with systems administrators to setup storage requirementsCollaborated with database developers and programmers to further development processesPerformed user management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the databaseAssisted database developers and end-users with on-call 24x7 remote supportEnsured daily RMAN backups were completed and valid for restore and recovery Monitored tablespace growth and expanded tablespaces through resizing and added data files
-
-
Education
-
2002 - 2004
University of Maryland Eastern Shore
Computer and Information Sciences and Support Services
Community
